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 “toled” 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.

335 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
toled6593492(None) 
coled85540761coled
doled75430911doled
holed95634131holed
poled84934841poled
soled65835171soled
stoled74521591stoled
tholed105113871tholed
tiled64832941tiled
toed56137041to_ed
toiled74420321toiled
toked105626491toked
told56132201tol_d
tole46052901tole_
toledo7419991toledo
toles55147131toles
tolled73819031tolled
toned65435341toned
tooled74918901tooled
toped85631311toped
toted64929481toted
towed95134581towed
toyed96019801toyed
voled95323721voled
abled86926832abled
ailed66240282ailed
atoned75417542atoned
axled135315812axled
baled85436442baled
bled75729312_bled
boded95124962boded
boiled95020952boiled
bold75432812bol_d
bole66448692bole_
boles75448602boles
bolled94722652bolled
bolted94617802bolted
boned85133242boned
booed85127272booed
bored85034302bored
bowed114533422bowed
bowled125018142bowled
boxed154318612boxed
coaled95022712coaled
coded95433182coded
coed77140542co_ed
coiled95123942coiled
coked124730692coked
cold77338772col_d
cole66956112cole_
colead94114642colead
coles76055062coles
coned86040052coned
cooed84534342cooed
cooled95224592cooled
coped105036852coped
cored85044222cored
coted85033852coted
coved115027372coved
cowed115637852cowed
cowled125218392cowled
coxed154322812coxed
coyed114623802coyed
deled75326542deled
doiled84817292doiled
dole56550002dole_
doles67843752doles
dolled83518072dolled
domed95423262domed
doped95326712doped
dosed76626912dosed
doted75227072doted
dowed104632612dowed
dozed165619352dozed
filed95331902filed
fled85429772_fled
foaled104515962foaled
foiled104618402foiled
fold86528942fol_d
folded114212792folded
foley115222302foley
fooled104317822fooled
fouled104315972fouled
fowled133914102fowled
foxed165115212foxed
gaoled84814502gaoled
gled65631142_gled
goaled85014362goaled
gold65430162gol_d
golem8416112golem
golfed11569762golfed
gored75227082gored
haled95335822haled
hoed87837982ho_ed
hoked135326992hoked
hold86235062hol_d
hole77553392hole_
holes84748652holes
holey115626902holey
holked144913662holked
homed115425422homed
honed95332262honed
hoped115628182hoped
hosed95830982hosed
howled134014972howled
idled74915212idled
isled64615992isled
joked175217912joked
jole117233822jole_
joles125230832joles
jolted143510632jolted
jowed164724422jowed
jowled174210802jowled
joyed164811832joyed
led46254562__led
lobed86022132lobed
lolled74315822lolled
looed64626132looed
loped85128332loped
loved95021362loved
lowed95233902lowed
loxed135017052loxed
mobled113213182mobled
moiled94318862moiled
mold76034332mol_d
molded104414082molded
mole66251832mole_
moles74747922moles
molted94217472molted
mooed85123982mooed
moped105424732moped
moved114218152moved
mowed113629012mowed
muled85824432muled
naled65525052naled
nosed65524562nosed
noted65123842noted
ogled75915962ogled
ohed87825182_ohed
oiled64429472oiled
old47033472_ol_d
ole37155212_ole_
olea46532722_olea
oleo46630482_oleo
oles46453472_oles
oohed94214212oohed
oozed154214262oozed
oped76230152_oped
owed86833872_owed
paled85538722paled
piled85232992piled
pled75231432_pled
poked125425392poked
pole65951302pole_
poler74431792poler
poles75351002poles
polled94022002polled
pooed85226242pooed
pooled94619812pooled
pored85234512pored
posed85828412posed
poxed154817862poxed
puled84926522puled
riled65833252riled
robed85323732robed
roiled74320052roiled
role45851822role_
roles56747982roles
rolfed104510522rolfed
rolled74220242rolled
roped84630812roped
rosed65930352rosed
roved95323552roved
rowed94034322rowed
ruled65822522ruled
sled55334372_sled
soiled73822472soiled
sold54837412sol_d
sole46053672sole_
solei55624342solei
soles55547922soles
solid65025082solid
soloed74515742soloed
solved105312932solved
sored66141782sored
souled75419822souled
sowed94933862sowed
staled74728102staled
stoked114718292stoked
stole54928812stole_
stolen64315062stolen
stoles63927672stoles
stolid74213182stolid
stoned75923142stoned
stooled84313892stooled
stoped94721012stoped
stored75524212stored
stowed105817202stowed
styled105613102styled
tabled94020042tabled
tailed74424662tailed
talced93811002talced
tale46154162tale_
taler56034872taler
tales55451372tales
talked114015402talked
tamed85528512tamed
taped85327422taped
tared69340052tared
tawed95926192tawed
taxed135620292taxed
ted46446572t__ed
teed55439262t_eed
tele45040872tele_
teledu737302teledu
teles54536002teles
telex125214822telex
tewed94718532tewed
thole85620842thole_
tholes94919782tholes
thoued10429002thoued
tided76322522tided
tied55535222t_ied
tilde65017352tilde
tile45451452tile_
tiler56131022tiler
tiles55542102tiles
tilled74722952tilled
tilted74616862tilted
timed85223612timed
tined65434532tined
tired65228902tired
tirled74714362tirled
titled73815002titled
toad55830182to_ad
tod49457082to__d
toddled10328822toddled
toe310166852to_e_
toea46732332to_ea
toes46956442to_es
togaed84711342togaed
togged95117512togged
toggled10428652toggled
toile54626492toile_
toiler63918282toiler
toiles63923512toiles
toilet66228092toilet
toited74016752toited
toke86738492toke_
token95419312token
toker95924912toker
tokes95234972tokes
tola45236332tol_a
tolan55124012tolan
tolar55524112tolar
tolas54532772tolas
toledos8388862toledos
toll45535262tol_l
toller63819442toller
tolls54728432tolls
tolu45529152tol_u
toluid738212toluid
tolus55024482tolus
tolyl84710092tolyl
tombed113812132tombed
tome67543192tome_
tomes76037382tomes
tommed113310142tommed
tone46953742tone_
toner55336242toner
tones56048662tones
toney86027412toney
tonged86518912tonged
tonlet62924702tonlet
tooler63818612tooler
tooted74620122tooted
tootled83511042tootled
tope65946382tope_
topee76029952topee
toper75231022toper
topes76941762topes
topped114617722topped
toppled12348842toppled
tore47359322tore_
tores55352672tores
tossed74215222tossed
totaled839692totaled
tote46643672tote_
totem74819372totem
toter55932132toter
totes55139682totes
totted74319952totted
toured74216152toured
toused74122012toused
tousled84710362tousled
touted74419742touted
touzled17367152touzled
towel84920522towel
toweled112410222toweled
tower85729202tower
toyer84521552toyer
treed65626732treed
tried65026912tried
troked114114582troked
trolled84312262trolled
trowed104714652trowed
trued65117692trued
tsked105910032tsked
tubed85818042tubed
tule45735872tule_
tules54532792tules
tuned64622312tuned
tweed94915092tweed
tyned95915012tyned
typed115815452typed
tyred95816432tyred
unled64021072unled
vole75236982vole_
voles86234042voles
voted93919142voted
vowed124424572vowed
waled94331002waled
wiled95231552wiled
wold85429072wol_d
wolfed13428012wolfed
wooed94419872wooed
wooled103715502wooled
wowed124023772wowed
wyled124611842wyled
yodled11389652yodled
yoked134821622yoked
yolked14367152yolked
yowed1253025182yowed
yowled133811092yowled
zoned154020262zoned

Search took 4 seconds 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 Filter178691538000.623286823.4
2DLD Change Limit538003353.06317564.5
3Display Results3353350.0933602.2
 (SQL Overall)1786913353.77947285.3
 
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.