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

183 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
toiles6392351(None) 
etoiles7411291etoiles
tiles55542101t_iles
toile54626491toile_
toiled74420321toiled
toiler63918281toiler
toilers74116261toilers
toilet66228091toilet
toilets74112911toilets
toils54527491toil_s
toles55147131to_les
voiles94616441voiles
biles75542142_biles
bogles95020832bogles
boiled95020952boiled
boiler84319272boiler
boilers93417062boilers
boils75427192boil_s
boites84322702boites
boles75448602bo_les
boules84925972boules
chiles115425302chiles
cobles104622882cobles
coiled95123942coiled
coiler84421592coiler
coilers93619902coilers
coils75030082coil_s
coles76055062co_les
colies84837052colies
doiled84817292doiled
doilies84017362doilies
doles67843752do_les
ediles74016982ediles
etoile6312262etoile_
exiles134816402exiles
files85441272_files
foibles1238852foibles
foiled104618402foiled
foils85025812foil_s
folles93820472folles
guiles73919282guiles
hoises94823682hoises
holes84748652ho_les
holies94630032holies
hoyles12315012hoyles
joles125230832jo_les
joules134116822joules
koines10415732koines
mailes84329112mailes
miles74645072_miles
mobiles112813122mobiles
moiled94318862moiled
moiler84017262moiler
moilers93615202moilers
moils76125752moil_s
moires8915632moires
moles74747922mo_les
molies84429512molies
motiles93317432motiles
nobles83319722nobles
noils55024332noil_s
noises65021852noises
ogles65223182_ogles
oiled64429472_oiled
oiler54628282_oiler
oilers64721192_oilers
oils46337972_oil_s
oles46453472_o_les
oodles73517182oodles
orles55326212_orles
piles74742612_piles
poilus82210572poilus
poises84226542poises
poles75351002po_les
polies84034582polies
riles55343642_riles
robles85321692robles
roiled74320052roiled
roils54826792roil_s
roles56747982ro_les
smiles84522292smiles
socles8418452socles
soiled73822472soiled
soils55327982soil_s
soles55547922so_les
spiles84227912spiles
stiles64328772stiles
stoles63927672sto_les
tables84524892tables
tailed74424662tailed
tailer63823732tailer
tailers73720182tailers
tailles72516472tailles
tails55634192tail_s
tales55451372t_ales
teles54536002t_eles
thills95515382thills
tholes94919782tholes
tides64830152t_ides
ties45248312t_i_es
tikes95628902t_ikes
tildes74513962t_ildes
tile45451442t_ile_
tiled64832942t_iled
tiler56131022t_iler
tilers63523502t_ilers
tills54631712t_ills
tils45739612t_il_s
tilts55325612t_ilts
times75630822t_imes
tines54848422t_ines
tires55437492t_ires
titles63719922titles
tobies84521022tobies
toddles93211532toddles
todies74223552todies
toeless72612392toeless
toes46956442to__es
toggles93710972toggles
togues76014242togues
toil46536282toil__
toited74016752toited
toits55327472toi_ts
tokes95234972to_kes
tolas54532772to_las
tole46052902to_le_
toled65934922to_led
tolled73819032tolled
toller63819442toller
tollers73217462tollers
tolls54728432to_lls
tolus55024482to_lus
tomes76037382to_mes
tones56048662to_nes
tonlet62924702tonlet
tonlets73212502tonlets
tonnes65320852tonnes
tooled74918902tooled
tooler63818612tooler
toolers74416502toolers
tools55325242tool_s
tootles72915602tootles
topees85519702topees
topes76941762to_pes
tophes115218422tophes
topless92511122topless
topples113111652topples
toques154612352toques
tores55352672to_res
tories65435882tories
torses64727952torses
tortes64826052tortes
toshes94520102toshes
tosses65225392tosses
totes55139682to_tes
touses64229672touses
tousles74113932tousles
touzles16359222touzles
towels94314642towels
towies93521192towies
toxines142912262toxines
toyless10268712toyless
tribes85119022tribes
trices84826332trices
tries55742812tri_es
trifles103814822trifles
trikes105419492trikes
trills64319852trills
trines64132562trines
tripes85324872tripes
triples94616872triples
troilus736412troilus
tuilles72411922tuilles
tules54532792t_ules
tulles63218892tulles
twills9489792twills
twines94717272twines
voices114414012voices
voile84719722voile_
voles86234042vo_les
whiles124418012whiles
wiles85437872_wiles
yodles103714332yodles

Search took 7 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 Filter178691825510.610292936.1
2DLD Change Limit825511835.48315055.8
3Display Results1831830.343533.5
 (SQL Overall)1786911836.43627764.3
 
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.