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

189 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
goatlike134629(None) 
boatlike1457961boatlike
gnatlike1334741gnatlike
goadlike1435881goadlike
moatlike1446991moatlike
oatlike113412401_oatlike
batlike133311882_batlike
boltlike1436312boltlike
catlike132712932_catlike
fatlike142911192_fatlike
foamlike1735142foamlike
footlike1537252footlike
gatelike1337932g_atelike
ghostlike1743352ghostlike
giantlike1443262giantlike
goalie7413162goa_li_e
godlike1387562go_dlike
gonglike1455422gonglike
gutlike12308652g_utlike
hatlike143311712_hatlike
loftlike1534392loftlike
oaklike10268002_oaklike
oarlike113411192_oarlike
poetlike1436732poetlike
potlike13910122po_tlike
ratlike113912352_ratlike
rootlike1236612rootlike
soaplike1436902soaplike
toadlike1336142toadlike
alike95523963__a_like
antlike11312073_antlike
auntlike1234983auntlike
axlike17388853__axlike
baglike14338943_baglike
beadlike15137253beadlike
beaklike13155773beaklike
beamlike16115843beamlike
beanlike14146843beanlike
bearlike14156793bearlike
boardlike1643313boardlike
boatlift1344683boatlift
bowlike16349473bo_wlike
bowllike1734863bowllike
boxlike20267073bo_xlike
clamlike1635163clamlike
clawlike1733913clawlike
claylike1734463claylike
coastline1196363coastline
cocklike1536733cocklike
cokelike1336813cokelike
comblike1846293comblike
cordlike1537233cordlike
corklike1335993corklike
cormlike1646703cormlike
crablike1636023crablike
cultlike1434933cultlike
deathlike1753823deathlike
doglike13207453do_glike
domelike15177753domelike
dovelike16157133dovelike
downlike1636183downlike
dustlike1335363dustlike
fadlike15318483_fadlike
fanlike142610503_fanlike
feltlike1534983feltlike
flatline11298923flatline
folklike1434773folklike
forklike1435813forklike
foxlike21226223fo_xlike
gamelike1538033gamelike
gantline9410903gantline
garpike1435093g_arpike
gemlike14206813g_emlike
germlike1535093germlike
gladelike1544153gladelike
glenlike1334043glenlike
globelike1643853globelike
gluelike1335023gluelike
gnathite1244483gnathite
gnomelike1643563gnomelike
goalies8316023goa_lies
goaling93515333goa_ling
goatee73219533goat__ee
goatfish1544293goatfish
goatish1139563goat_ish
goatskin1342773goatskin
goethite1244053goethite
gothite1146403go_thite
grapelike1644663grapelike
grapline1138723grapline
grasslike1443693grasslike
gratine84719193grat_ine
gravelike1744513gravelike
gulflike1643453gulflike
gumlike14317403g_umlike
heathlike1944323heathlike
hoblike16158303ho_blike
hoelike141411163ho_elike
hoglike15157733ho_glike
homelike17179533homelike
hoodlike1636563hoodlike
hooflike1834853hooflike
hooklike1435123hooklike
hooplike1736773hooplike
hornlike1536503hornlike
hoselike15179643hoselike
hotline10712353ho_tline
hutlike14349063_hutlike
jamlike20126923_jamlike
jawlike21116003_jawlike
jetlike18276763_jetlike
kiltlike1134243kiltlike
knotlike1144003knotlike
lawlike14137073_lawlike
leaflike1534713leaflike
lordlike1345813lordlike
manlike133012783_manlike
maplike15299273_maplike
mastlike1437863mastlike
moonlike1476643moonlike
mosslike1435453mosslike
mothlike1736063mothlike
mouthlike1843533mouthlike
nestlike1236083nestlike
netlike11308913_netlike
nooklike1134873nooklike
noselike12158573noselike
novalike1536223novalike
nutlike113110113_nutlike
oatcake1345363_oatcake
outlie62419533_outli_e
outline72321333_outline
outlive102513033_outlive
owllike1435713_owllike
oxlike17307473_o_xlike
peaklike13115373peaklike
pealike131211273pea_like
plantlike1544943plantlike
platelike1546143platelike
playlike1735613playlike
podlike14108553po_dlike
popelike16177853popelike
potline91015233po_tline
quaylike2434143quaylike
ratline74517803_ratline
raylike14269253_raylike
rocklike1335903rocklike
rodlike1288263ro_dlike
rooflike1534623rooflike
ropelike14157853ropelike
roselike12169183roselike
saclike131210123_saclike
saltlike1237253saltlike
sawlike14138443_sawlike
scablike1635553scablike
seallike12108323seallike
seamlike14127183seamlike
slablike1435673slablike
slatelike1346153slatelike
slitlike1235303slitlike
snaglike1335283snaglike
songlike1336523songlike
sonlike112110713so_nlike
soullike1236813soullike
souplike1436333souplike
sparlike1437673sparlike
starlike1238813starlike
suitlike1236313suitlike
swanlike1535313swanlike
taglike12278913_taglike
tealike111111083tea_like
tentlike1236903tentlike
toelike11149823to_elike
tomblike1645143tomblike
toothlike1643723toothlike
totalise8312503totalise
totalize17311523totalize
toylike14157243to_ylike
traplike1437653traplike
unalike11311533una_like
vestlike1535393vestlike
warlike142410473_warlike
wartlike1537043wartlike
waxlike21185973_waxlike
wolflike1834063wolflike
womanlike1843453womanlike
woollike1534983woollike
wormlike1735313wormlike
yeastlike1672993yeastlike

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 Limit1461621896.75021653.6
3Display Results1891890.0762486.8
 (SQL Overall)1786911897.26224606.3
 
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.