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 “upcoil” with Change Limit: [1] [2] [3]

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

127 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
upcoil1012619(None) 
uncoil8811851uncoil
upboil1096451upboil
upcoils1184931upcoils
coil66439652__coil
recoil84016722recoil
spoil75818652sp_oil
uncoils979532uncoils
uncool8610112uncool
upboils1184702upboils
upcoiled13215182upcoiled
upcurl1034962upcurl
aboil72217543_aboil
archil11611573archil
assoil688543assoil
boil66335183__boil
broil74918223_broil
ceil65725063__ceil
coal66939253__coal
coif96337913__coif
coils75030083__coils
coin66645353__coin
coir66327243__coir
col59360353__co_l
cool66940493__cool
cowl97530813__cowl
dacoit9415453dacoit
entoil6912493entoil
euploid1038963euploid
foil76433913__foil
fucoid1237893fucoid
gumboil1244373gumboil
moil65534093__moil
mucoid1139783mucoid
nicol71113293nico_l
noil46133243__noil
oil37452053___oil
opioid9310083opioid
orchil1158653orchil
pail66141833_p_ail
peril75425953_peril
poi57244663_p_oi_
poilu72316003_p_oilu
pois66539043_p_ois
pol56449383_p_o_l
poll66332133_p_oll
pool65835953_p_ool
prowl105615123_prowl
pupil94712983_pupil
pyoid11513763_pyoid
reboil83814683reboil
recoal84117973recoal
recoils93814873recoils
recoin84320293recoin
reoil55321183_reoil
roil46235293__roil
scowl1012012973_scowl
soil46138833__soil
spail74921553sp_ail
speil75618643sp_eil
spoils84614533sp_oils
spoilt85016593sp_oilt
spool75219043sp_ool
subcool1146233subcool
subsoil967293subsoil
supercoil1357753supercoil
toil46536283__toil
topsoil977143topsoil
turmoil944723turmoil
unchic1338643unchic
unci65019463unc_i_
uncia75015163unc_ia
uncial83715223uncial
uncivil1244793uncivil
unclip1046993unclip
unco66021403unco__
uncock1438563uncock
uncoiled112512683uncoiled
uncomic1346923uncomic
uncork1239043uncork
uncos74117033unco_s
uncoy104111413unco_y
uncurl839413uncurl
unnail6410583unnail
unroll61210073unroll
until53517743u_ntil
unveil957343unveil
upboiled13194853upboiled
upbore10247883upbore
upbow1245613upbo_w
upbows1384683upbows
upbuild1243003upbuild
upbuilt1144043upbuilt
upcast102710093upcast
upclimb1542133upclimb
upcoast1165543upcoast
upcoiling1444793upcoiling
upcoming1535173upcoming
upcourt1146103upcourt
upcurls1143653upcurls
updo76712883updo__
updos8389513updo_s
updove1234483updove
upfold12124953upfold
upgoing1135353upgoing
uphill11106173uphill
uphold12126903uphold
uphove1436133uphove
uplit76020803up_lit
upload9257783upload
upmost1068193upmost
upo58925863up_o__
upon65817583up_o_n
uppile10178503up_pile
uproar8106933uproar
uproot8314123uproot
uprose82311483uprose
upsoar8105683upsoar
upstir835383upstir
uptilt8410803up_tilt
uptore8279453uptore
uptorn8268093uptorn
uptoss836093uptoss
uptown11274963uptown
upwell11285803upwell
uracil8311543uracil
urchin1138743urchin

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161275.15621861.1
3Display Results1271270.0462760.9
 (SQL Overall)1786911275.59231954.8
 
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.