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

139 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
snaglike133528(None) 
baglike14338942_baglike
fanglike1636822fanglike
gnatlike1334742gnatlike
saclike131210122s_aclike
sandlike1339712sandlike
sawlike14138442s_awlike
scablike1635552scablike
seallike12108322seallike
seamlike14127182seamlike
slablike1435672slablike
snaillike1343772snaillike
snakelike1244292snakelike
snowlike1534972snowlike
soaplike1436902soaplike
songlike1336522songlike
sparlike1437672sparlike
stagelike1445342stagelike
starlike1238812starlike
swanlike1535312swanlike
taglike12278912_taglike
unalike11311532una_like
alike95523963__a_like
anglice1089213an_glice
antlike11312073an_tlike
axlike17388853__axlike
batlike133311883_batlike
beadlike15137253beadlike
beaklike13155773beaklike
beamlike16115843beamlike
beanlike14146843beanlike
bearlike14156793bearlike
boatlike1457963boatlike
cagelike1537723_cagelike
catlike132712933_catlike
clamlike1635163clamlike
clawlike1733913clawlike
claylike1734463claylike
crablike1636023crablike
doglike13207453_doglike
dragline1036843dragline
fadlike15318483_fadlike
fanlike142610503_fanlike
fatlike142911193_fatlike
foamlike1735143foamlike
froglike1634363froglike
goadlike1435883goadlike
goatlike1346293goatlike
gonglike1455423gonglike
handlike1639153handlike
hatlike143311713_hatlike
hoglike15157733_hoglike
inklike1037033in_klike
jamlike20126923_jamlike
jawlike21116003_jawlike
jiglike19105333_jiglike
kinglike1235093kinglike
knoblike1343163knoblike
knotlike1144003knotlike
lawlike14137073_lawlike
leaflike1534713leaflike
leglike12136843_leglike
manlike133012783_manlike
maplike15299273_maplike
moatlike1446993moatlike
neglige934873_neglige
netlike11308913_netlike
niblike1336703_niblike
nunlike11258073_nunlike
nutlike113110113_nutlike
oaklike10268003_oaklike
oarlike113411193_oarlike
oatlike113412403_oatlike
peaklike13115373peaklike
pealike131211273pea_like
peglike14136773_peglike
piglike14157313_piglike
playlike1735613playlike
quaylike2434143quaylike
ratlike113912353_ratlike
raylike14269253_raylike
ringlike1336243ringlike
ruglike1236283_ruglike
sacklike1337303sacklike
saline65132703s_a_line
saltlike1237253saltlike
sanguine947633sanguine
scalelike1545253scalelike
scumlike1644353scumlike
seedlike1335993seedlike
serflike1536273serflike
shalelike1645883shalelike
sharklike1543933sharklike
shaslik1444513shaslik_
shasliks1544143shasliks
sheaflike1942973sheaflike
shedlike1635833shedlike
sighlike1635533sighlike
silklike1135523silklike
sinuslike1343503sinuslike
skinlike1134873skinlike
skylike1336103s_kylike
slatelike1346153slatelike
slitlike1235303slitlike
snaggier10136303snaggier
snagging11319373snagging
snailing92912973snailing
snake94821113sna___ke
snarlier8278183snarlier
snarling92513183snarling
sonlike112110713s_onlike
soullike1236813soullike
souplike1436333souplike
spearlike1544143spearlike
staggie9138463staggi_e
stairlike1344753stairlike
stalklike1243903stalklike
stemlike1436723stemlike
steplike1436733steplike
suchlike1735123suchlike
sugarlike1443243sugarlike
suitlike1236313suitlike
sunlike112310573s_unlike
surflike1535933surflike
swaggie12135783swaggi_e
tagline82412453_tagline
tangolike1453843tangolike
tanklike1136013tanklike
tealike111111083tea_like
toadlike1336143toadlike
traplike1437653traplike
twiglike1642793twiglike
unagile838283unag_ile
unlike102614063un__like
unwarlike1652883unwarlike
warlike142410473_warlike
waxlike21185973_waxlike
wiglike15125853_wiglike
winglike1635593winglike

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.420425454.8
2DLD Change Limit1461621396.53322372.9
3Display Results1391390.0602316.7
 (SQL Overall)1786911397.01325480.0
 
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.