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

140 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
wormlike173531(None) 
cormlike1646701cormlike
armlike1348552_armlike
cordlike1537232cordlike
corklike1335992corklike
foamlike1735142foamlike
forklike1435812forklike
germlike1535092germlike
hornlike1536502hornlike
lordlike1345812lordlike
swordlike1742712swordlike
warlike142410472war_like
wartlike1537042wartlike
wirelike15167492wirelike
wolflike1834062wolflike
woollike1534982woollike
airlike11310333air_like
balmlike1655353balmlike
barnlike1437183barnlike
beamlike16115843beamlike
birdlike1535233birdlike
boardlike1643313boardlike
boatlike1457963boatlike
boltlike1436313boltlike
bowlike16349473bo_wlike
bowllike1734863bowllike
boxlike20267073bo_xlike
clamlike1635163clamlike
cocklike1536733cocklike
cokelike1336813cokelike
comblike1846293comblike
doglike13207453do_glike
domelike15177753domelike
dormice1237133dorm_ice
dormie9312623dorm_i_e
dovelike16157133dovelike
downlike1636183downlike
drumlike1543793drumlike
dwarflike2041613dwarflike
fernlike1535243fernlike
filmlike1734443filmlike
folklike1434773folklike
footlike1537253footlike
formalise14239783formalise
formalize232710033formalize
formulize23265623formulize
foxlike21226223fo_xlike
froglike1634363froglike
gemlike14206813_gemlike
goadlike1435883goadlike
goatlike1346293goatlike
godlike1387563go_dlike
gonglike1455423gonglike
gumlike14317403_gumlike
harelike1539613harelike
herblike1735883herblike
herdlike1636113herdlike
hoblike16158303ho_blike
hoelike141411163ho_elike
hoglike15157733ho_glike
homelike17179533homelike
hoodlike1636563hoodlike
hooflike1834853hooflike
hooklike1435123hooklike
hooplike1736773hooplike
horselike1646263horselike
hoselike15179643hoselike
ironlike1235713ironlike
ivorylike1941423ivorylike
jamlike20126923_jamlike
lardlike1336503lardlike
loftlike1534393loftlike
moatlike1446993moatlike
moonlike1476643moonlike
moralise10314913moralise
moralize19313923moralize
mosslike1435453mosslike
mothlike1736063mothlike
nooklike1134873nooklike
normalise11259423normalise
normalize203010103normalize
noselike12158573noselike
novalike1536223novalike
oaklike10268003_oaklike
oarlike113411193_oarlike
oatlike113412403_oatlike
owllike1435713_owllike
oxlike17307473_o_xlike
palmlike1656043palmlike
parklike1337493parklike
plumlike1643793plumlike
podlike14108553po_dlike
poetlike1436733poetlike
popelike16177853popelike
potlike13910123po_tlike
rocklike1335903rocklike
rodlike1288263ro_dlike
rooflike1534623rooflike
rootlike1236613rootlike
ropelike14157853ropelike
roselike12169183roselike
scumlike1644353scumlike
seamlike14127183seamlike
serflike1536273serflike
soaplike1436903soaplike
songlike1336523songlike
sonlike112110713so_nlike
soullike1236813soullike
souplike1436333souplike
stemlike1436723stemlike
surflike1535933surflike
thornlike1643003thornlike
toadlike1336143toadlike
toelike11149823to_elike
tomblike1645143tomblike
torchlike1843713torchlike
toylike14157243to_ylike
turflike1534443turflike
urnlike1136713_urnlike
waiflike1834573waiflike
wasplike1734893wasplike
wavelike1836613wavelike
waxlike21185973w_axlike
weblike1635923w_eblike
weedlike1634393weedlike
wheylike2143403wheylike
whiplike2043813whiplike
wifelike18135253wifelike
wiglike15125853w_iglike
winglike1635593winglike
wisplike1734713wisplike
womanlike1843453womanlike
woolie93514483wo_oli_e
workmanlike1951253workmanlike
wormhole1644663wormhole
wormier12278763worm_ier
wormil1138043worm_i_l
wormils1236733worm_ils
worming132811243worm_ing
wormish1537163worm_ish

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621407.39319770.3
3Display Results1401400.0602333.3
 (SQL Overall)1786911407.88922650.7
 
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.