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

142 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
voile8471972(None) 
toile54626491toile
vile76139801v_ile
voice104915321voice
voila84813941voila
voiles94616441voiles
vole75236981vo_le
agile65122262agile
anile54634462anile
axile126020512axile
bile66147182_bile
bogle85821682bogle
boil66335182boil_
boiled95020952boiled
boiler84319272boiler
boils75427192boils
boite74426322boite
bole66448692bo_le
boule74828042boule
chile105626892chile
coble94823172coble
coil66439652coil_
coiled95123942coiled
coiler84421592coiler
coils75030082coils
cole66956112co_le
docile94213122docile
doiled84817292doiled
doily95321032doily
dole56550002do_le
edile64819492edile
etoile6312262etoile
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
ovine86316642ovine
ovule839492ovule
pile65649692_pile
poilu72316002poilu
poise75127892poise
pole65951302po_le
rile45650532_rile
roble75223022roble
roil46235292roil_
roiled74320052roiled
roils54826792roils
roily86121112roily
role45851822ro_le
smile74823922smile
socle7419572socle
soil46138832soil_
soiled73822472soiled
soils55327982soils
sole46053672so_le
spile75230082spile
stile54931572stile
tile45451442_tile
toil46536282toil_
toiled74420322toiled
toiler63918282toiler
toiles63923512toiles
toilet66228092toilet
toils54527492toils
tole46052902to_le
utile54718932utile
vagile10310542vagile
vail75432552vail_
vailed104619292vailed
vails85825932vails
vale74937342v_ale
veil75523592veil_
veiled103714542veiled
veiler93814352veiler
veils84918802veils
vibe95124502v_ibe
vice95732852v_ice
vide85432752v_ide
vie65447632v_i_e
viler86324162v_iler
vill75235072v_ill
vine75643682v_ine
viol76523592viol_
viola85915542viola
violet92620922violet
viols86118102viols
virile9313432virile
vise75632672v_ise
vive105426622v_ive
voe67739052vo__e
vogie95116662vogie
vogue95613042vogue
voiced123910112voiced
voicer113910542voicer
voices114414012voices
void86220562voi_d
voided114011132voided
voider103611552voider
voids95414672voids
voled95323722vo_led
voles86234042vo_les
volley12419742volley
volt76439532vo_lt
volte85321302volte
vote74728622vo_te
votive12348932votive
vowel115515012vowel
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.0762351197.4
2DLD Change Limit538001421.64032804.9
3Display Results1421420.0334303.0
 (SQL Overall)1786911421.749102167.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.