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

114 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
upcoils118493(None) 
uncoils979531uncoils
upboils1184701upboils
upcoil10126191upcoil_
coils75030082__coils
recoils93814872recoils
spoils84614532sp_oils
uncoil8811852uncoil_
upboil1096452upboil_
upcoiled13215182upcoiled
upcurls1143652upcurls
archils12510533archils
assoils776663assoils
boils75427193__boils
broils84114173_broils
ceils75019403__ceils
coals76129603__coals
coifs105718703__coifs
coil66439653__coil_
coins75834553__coins
coirs75221053__coirs
cols66553083__co_ls
cools75632633__cools
cowls106922213__cowls
dacoits1079073dacoits
entoils7810733entoils
euploids1157243euploids
foils85025813__foils
fucoids1335663fucoids
gumboils1343893gumboils
moils76125753__moils
mucoids1237423mucoids
nicols8810243nico_ls
noils55024333__noils
oils46337973___oils
opioids1036523opioids
orchils1277703orchils
pails75833063_p_ails
perils84121853_perils
poilu72316003_p_oilu
poilus82210573_p_oilus
pois66539043_p_oi_s
polis74731163_p_olis
polls74627723_p_olls
pols66044563_p_o_ls
pools74427703_p_ools
prowls115511083_prowls
pupils10389913_pupils
reboils94111723reboils
recoals94214633recoals
recoil84016723recoil_
recoins94019243recoins
reoils64516873_reoils
roils54826793__roils
scowls11549593_scowls
soils55327983__soils
spails84817823sp_ails
speils84116223sp_eils
spoil75818653sp_oil_
spoilt85016593sp_oilt
spools85115913sp_ools
subcools1245753subcools
subsoils1076653subsoils
supercoils1487493supercoils
toils54527493__toils
topsoils1095143topsoils
turmoils1043983turmoils
uncials92510523uncials
unclips1136433unclips
uncocks1537233uncocks
uncoiled112512683uncoiled
uncool8610113uncool_
uncorks1337443uncorks
uncos74117033unco__s
uncurls937123uncurls
unnails738223unnails
unrolls797793unrolls
unveils1045753unveils
upboiled13194853upboiled
upbows1384683upbo_ws
upbuild1243003upbuild
upbuilds1341753upbuilds
upbuilt1144043upbuilt
upcasts11185643upcasts
upclimb1542133upclimb
upclimbs1641363upclimbs
upcoast1165543upcoast
upcoiling1444793upcoiling
upcoming1535173upcoming
upcourt1146103upcourt
upcurl1034963upcurl_
updos8389513updo__s
updries10209083updries
upfold12124953upfo_ld
upfolds13133753upfolds
upgoing1135353upgoing
uphill11106173up_hill
uphills1295233uphills
uphold12126903upho_ld
upholds13135243upholds
uploads10266503uploads
uppile10178503up_pile
uppiles11208263up_piles
uproars986453uproars
uproots937143uproots
upsoars985413upsoars
upstirs935293upstirs
uptilt8410803up_tilt
uptilts934733up_tilts
uptoss836093upto_ss
uptowns12194343uptowns
upwells12244303upwells
uracils939373uracils
urchins1238863urchins

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271145.70323501.1
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.15529031.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.