Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “fur” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

340 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
fur6663732(None) 
bur55744691bur
cur56841981cur
far67762601far
fer66646121fer
fir66744901fir
for66952071for
four76226861four
fub86337391fub
fud76335161fud
fug76234511fug
fun66841141fun
furl77030881furl
furs76735041furs
fury107727971fury
our36042891our
pur56840551pur
afar76720782afar
air38058402air
ar211379382_ar
auk76234142auk
aura45836252aura
bar58070552bar
blur66020532blur
brr56921922brr
bub76343982bub
bud67041282bud
bug65340742bug
buhr95315382buhr
bum75342692bum
bun56348142bun
bura66139532bura
burb85334672burb
burd75534262burd
burg74930362burg
burl64937182burl
burn65636432burn
burp85028882burp
burr65631232burr
burs65847422burs
bury95633592bury
bus56950972bus
but55963022but
buy86436542buy
car59165562car
cor59960942cor
cru57129562cru
cub76940942cub
cud67937462cud
cue57544182cue
cum76440162cum
cup76738242cup
curb86732222curb
curd77634982curd
cure66149122cure
curf97538782curf
curl66035052curl
curn66731892curn
curr65429652curr
curs65645542curs
curt67051712curt
cut57957662cut
dor47253922dor
dour56330432dour
dub66642202dub
dud56737602dud
due45249862due
dug58138692dug
duh77930382duh
dui46433382dui
dun46545582dun
duo48536142duo
dup67637882dup
dura55232112dura
dure56341812dure
durn56127632durn
duro56228022duro
durr55624352durr
ear36867882ear
er28345142_er
err35626532err
euro45325272euro
fa510148452f_a
fab87453132fab
fad77452422fad
fag76852362fag
fair76332522fair
fan67158862fan
fard85639062fard
fare76354462fare
farl76338552farl
farm95934542farm
faro76136922faro
fart76860562fart
fas68262932fas
fat68178082fat
faun76226622faun
faux146519072faux
fax138143312fax
fay97454862fay
fe57944742f_e
fear75337792fear
fed76548362fed
fee66862012fee
feh96136092feh
fem86040732fem
femur1038682femur
fen66851352fen
fere76342232fere
fern76129322fern
fes66551672fes
fet66471632fet
feu67843662feu
feuar8310242feuar
feud86523022feud
feus75830752feus
few95436962few
fey95940882fey
fez156236822fez
fiar76427342fiar
fib86344282fib
fid76847702fid
fie67152452fie
fig76242842fig
fil65447152fil
fin66458042fin
fire76245602fire
firm96026462firm
firn76927512firn
firs76637722firs
fit66365462fit
fix136236112fix
fiz156238772fiz
flir76422202flir
flour84916452flour
flu66530212flu
flub95721882flub
flue75329852flue
fluor84512772fluor
flus75626542flus
flux145617742flux
fly97124952fly
fob86748332fob
foe66350812foe
fog76945562fog
foh98135892foh
fon66352272fon
fop86743702fop
fora75937392fora
forb97131332forb
ford86835492ford
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
fou66743782fou
foul77027582foul
fours85521492fours
fox136737862fox
foy96044262foy
fro65530642fro
frug86517102frug
fry96226502fry
fubar1039922fubar
fubs96328792fubs
fuci95720312fuci
fuck134924632fuck
fuds86528572fuds
fuel76824732fuel
fugs85730692fugs
fugu85419862fugu
fuji144112002fuji
full75229152full
fume96727632fume
fumer105918232fumer
fumy127118582fumy
fund85624982fund
funk115825622funk
funs75235732funs
furan84320012furan
furls85322052furls
furor8312392furor
furry116719282furry
furze176815812furze
furzy2010116062furzy
fuse76429992fuse
fuss76027932fuss
futz167823802futz
fuze166422372fuze
fuzz158420572fuzz
gar47259902gar
gaur56723352gaur
gor47848262gor
guar56923292guar
gul45832792gul
gum67439532gum
gun47240802gun
guru54623912guru
gut46753852gut
guv74523172guv
guy75728942guy
her66547812her
hour75827312hour
hub86437482hub
hue66642302hue
hug76037362hug
huh96432012huh
hum85542932hum
hun65844712hun
hup86437812hup
hurl76029932hurl
hurt77142572hurt
hut66457292hut
jar107646152jar
jug115529542jug
jun105932062jun
jura116024892jura
jury146719592jury
jus106930222jus
jut105944012jut
kir76535692kir
knur85311982knur
kor76538902kor
kue76631872kue
kuru85521812kuru
lar37967532lar
lour45430682lour
lug46138062lug
lum55542932lum
lure45142462lure
lurk86624162lurk
luv67125772luv
lux106528772lux
mar57965952mar
mir57046782mir
mor56855002mor
mu46737482mu_
mud67336872mud
mug65837692mug
mum76643612mum
mun56143862mun
mura65633302mura
mure65941332mure
murk105527252murk
murr65225132murr
mus55946752mus
mut58357182mut
nor38048822nor
nu26331952nu_
nub56439142nub
nun35537742nun
nurd56224342nurd
nurl45327242nurl
nus37939392nus
nut36651962nut
oar37057952oar
or27354732_or
oud47439082oud
ours47237562ours
out38072152out
par57467022par
per56353092per
pfui9349792pfui
pour611527472pour
pub76037692pub
pud65836662pud
pug65337182pug
pul56138062pul
pun58846512pun
pup76339882pup
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
pus55547842pus
put55759072put
qua124821972qua
rub56342822rub
rue35549262rue
ruer46127562ruer
rug46039152rug
rum56644642rum
run36244992run
rut35560522rut
ser36752402ser
sir35746682sir
slur45525152slur
sour45935892sour
spur65321192spur
sub55445552sub
sue35651462sue
suer45334032suer
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
sura45740292sura
surd56433812surd
sure45447412sure
surf76039312surf
tar37570692tar
tor39261682tor
tour45530382tour
tub55640032tub
tug45937402tug
tui37034022tui
tun35845192tun
tup56037542tup
turd56027622turd
turf75334052turf
turk86125862turk
turn46330392turn
tut36758092tut
tux105426572tux
uh57429852_uh
um47338832_um
un28341142_un
up47832822_up
urb55731112_urb
urd46427062_urd
urn35731472_urn
urp56426402_urp
us26937432_us
ut28647032_ut
var66148332var
vug76127412vug
vum85428652vum
war67262422war
waur76819902waur
wud76227162wud
xu96018832xu_
yar67253832yar
your78623432your
yuk106725602yuk
yum86132822yum
yup86031702yup
yurt76435042yurt
zuz1110622032zuz

Search took 1 second overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691140840.266671770.7
2DLD Change Limit140843400.40634689.7
3Display Results3403400.0605666.7
 (SQL Overall)1786913400.732244113.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.