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

187 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
toile5462649(None) 
etoile6312261etoile
tile45451441t_ile
toil46536281toil_
toiled74420321toiled
toiler63918281toiler
toiles63923511toiles
toilet66228091toilet
toils54527491toils
tole46052901to_le
voile84719721voile
agile65122262agile
anile54634462anile
axile126020512axile
bile66147182_bile
bogle85821682bogle
boil66335182boil_
boiled95020952boiled
boiler84319272boiler
boils75427192boils
boite74426322boite
bole66448692bo_le
boule74828042boule
chile105626892chile
coble94823172coble
coil66439652coil_
coiled95123932coiled
coiler84421592coiler
coils75030082coils
cole66956112co_le
docile94213122docile
doiled84817292doiled
doily95321032doily
dole56550002do_le
edile64819492edile
etoiles7411292etoiles
exile126117652exile
file75446642_file
foible11410382foible
foil76433912foil_
foiled104618402foiled
foils85025812foils
guile64521132guile
hoise85224772hoise
hole77553392ho_le
hoyle11314412hoyle
jole117233822jo_le
joule124918202joule
koine9516482koine
maile75232222maile
mile66352572_mile
mobile103613542mobile
moil65534092moil_
moiled94318862moiled
moiler84017262moiler
moils76125752moils
moire71017322moire
mole66251832mo_le
motile83818342motile
noble74420992noble
noil46133242noil_
noils55024332noils
noily86120992noily
noise55723732noise
ogle56325052_ogle
oil37452052_oil_
oiled64429472_oiled
oiler54628282_oiler
oils46337972_oils
oily77932252_oily
ole37155212_o_le
orle45630462_orle
pile65649692_pile
poilu72316002poilu
poise75127892poise
pole65951302po_le
rile45650532_rile
roble75223022roble
roil46235292roil_
roiled74320052roiled
roils54826792roils
roily86121112roily
role45851822ro_le
smile74823922smile
socle7419572socle
soil46138822soil_
soiled73822472soiled
soils55327982soils
sole46053672so_le
spile75230082spile
stile54931572stile
stole54928812sto_le
table75429602table
tail45443652tail_
tailed74424662tailed
tailer63823732tailer
taille63116922taille
tails55634192tails
tale46154162t_ale
tele45040872t_ele
thill85918732thill
thine85026852thine
thole85620842thole
tide55237372t_ide
tie36557532t_i_e
tike85534482t_ike
til36350262t_il_
tilde65017342t_ilde
tiled64832942t_iled
tiler56131022t_iler
tiles55542102t_iles
till45941202t_ill
tils45739612t_ils
tilt46252422t_ilt
time66235012t_ime
tine45855132t_ine
tire46143352t_ire
title54721072title
toddle85811032toddle
toe310166852to__e
togae67020112togae
toggle83810872toggle
togue64816302togue
toilers74116262toilers
toilets74112912toilets
toit46353062toi_t
toited74016752toited
toits55327472toits
toke86738492to_ke
tola45236332to_la
told56132202to_ld
toled65934922to_led
toles55147132to_les
toll45535262to_ll
tolled73819032tolled
toller63819442toller
tolls54728432tolls
tolu45529152to_lu
tome67543192to_me
tone46953742to_ne
tonlet62924702tonlet
tonne54921432tonne
tool46735682tool_
tooled74918902tooled
tooler63818612tooler
tools55325242tools
tootle62613812tootle
tope65946382to_pe
topee76029952topee
tophe106718972tophe
topple104411322topple
toque145113092toque
tore47359322to_re
torse55833332torse
torte55431702torte
tortile7313192tortile
tote46643672to_te
touse55430672touse
tousle64514652tousle
touzle15429002touzle
towel84920522towel
towie85821872towie
toxine133114122toxine
tribe74420272tribe
trice75127492trice
trifle94012882trifle
trike95320162trike
trill55122932trill
trine54734602trine
tripe75425382tripe
triple84215922triple
trite54730032trite
tuille63012642tuille
tule45735872t_ule
tulle54019932tulle
twice104711122twice
twill85612722twill
twine85822362twine
utile54718932utile
vile76139802_vile
voice104915322voice
voila84813942voila
voiles94616442voiles
vole75236982vo_le
while115418692while
wile75944372_wile
yodle94515042yodle

Search took 2 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.0931921408.6
2DLD Change Limit538001871.47036598.6
3Display Results1871870.0434348.8
 (SQL Overall)1786911871.606111264.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.