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

136 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
gnatlike133474(None) 
goatlike1346291goatlike
antlike11312072an_tlike
batlike133311882_batlike
boatlike1457962boatlike
catlike132712932_catlike
fatlike142911192_fatlike
gantline9410902gantline
gatelike1337932g_atelike
giantlike1443262giantlike
gnathite1244482gnathite
goadlike1435882goadlike
gutlike12308652g_utlike
hatlike143311712_hatlike
knotlike1144002knotlike
moatlike1446992moatlike
netlike11308912_netlike
nutlike113110112_nutlike
oatlike113412402_oatlike
ratlike113912352_ratlike
snaglike1335282snaglike
unalike11311532una_like
alike95523963__a_like
auntlike1234983auntlike
axlike17388853__axlike
baglike14338943_baglike
beadlike15137253beadlike
beaklike13155773beaklike
beamlike16115843beamlike
beanlike14146843beanlike
bearlike14156793bearlike
boltlike1436313boltlike
clamlike1635163clamlike
clawlike1733913clawlike
claylike1734463claylike
crablike1636023crablike
cultlike1434933cultlike
deathlike1753823deathlike
dustlike1335363dustlike
fadlike15318483_fadlike
fanglike1636823fanglike
fanlike142610503_fanlike
feltlike1534983feltlike
flatline11298923flatline
foamlike1735143foamlike
footlike1537253footlike
gamelike1538033gamelike
gantlines1039333gantlines
gantlope1144413gantlope
garpike1435093g_arpike
gemlike14206813g_emlike
germlike1535093germlike
ghostlike1743353ghostlike
gladelike1544153gladelike
glenlike1334043glenlike
gluelike1335023gluelike
gnarlier9255163gnarlier
gnarling10217603gnarling
gnathic1344843gnathi_c
gnathion1243443gnathion
gnathites1344233gnathites
gnattier934263gnattier
gnomelike1643563gnomelike
goalie7413163goa_li_e
godlike1387563g_odlike
gonglike1455423gonglike
grapelike1644663grapelike
grapline1138723grapline
grasslike1443693grasslike
gratine84719193grat_ine
gravelike1744513gravelike
gulflike1643453gulflike
gumlike14317403g_umlike
handlike1639153handlike
heathlike1944323heathlike
hutlike14349063_hutlike
inklike1037033in_klike
jamlike20126923_jamlike
jawlike21116003_jawlike
jetlike18276763_jetlike
kiltlike1134243kiltlike
knoblike1343163knoblike
lawlike14137073_lawlike
leaflike1534713leaflike
loftlike1534393loftlike
manlike133012783_manlike
maplike15299273_maplike
mastlike1437863mastlike
native9613013_nat_ive
nestlike1236083nestlike
niblike1336703_niblike
nunlike11258073_nunlike
oaklike10268003_oaklike
oarlike113411193_oarlike
peaklike13115373peaklike
pealike131211273pea_like
plantlike1544943plantlike
platelike1546143platelike
playlike1735613playlike
poetlike1436733poetlike
potlike13910123_potlike
quaylike2434143quaylike
ratline74517803_ratline
raylike14269253_raylike
rootlike1236613rootlike
saclike131210123_saclike
saltlike1237253saltlike
sandlike1339713sandlike
sawlike14138443_sawlike
scablike1635553scablike
seallike12108323seallike
seamlike14127183seamlike
slablike1435673slablike
slatelike1346153slatelike
slitlike1235303slitlike
snaillike1343773snaillike
snakelike1244293snakelike
snowlike1534973snowlike
soaplike1436903soaplike
sparlike1437673sparlike
starlike1238813starlike
suitlike1236313suitlike
swanlike1535313swanlike
taglike12278913_taglike
tanklike1136013tanklike
tealike111111083tea_like
tentlike1236903tentlike
toadlike1336143toadlike
traplike1437653traplike
unlike102614063un__like
unwarlike1652883unwarlike
vestlike1535393vestlike
warlike142410473_warlike
wartlike1537043wartlike
waxlike21185973_waxlike
yeastlike1672993yeastlike

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621366.48322545.4
3Display Results1361360.0632158.7
 (SQL Overall)1786911366.96925640.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.