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

163 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
foamlike173514(None) 
beamlike16115842beamlike
boatlike1457962boatlike
clamlike1635162clamlike
cormlike1646702cormlike
fadlike15318482f_adlike
fanlike142610502f_anlike
fatlike142911192f_atlike
filmlike1734442filmlike
flamelike1845062flamelike
folklike1434772folklike
footlike1537252footlike
forklike1435812forklike
foxlike21226222fo_xlike
goadlike1435882goadlike
goatlike1346292goatlike
jamlike20126922_jamlike
moatlike1446992moatlike
oaklike10268002_oaklike
oarlike113411192_oarlike
oatlike113412402_oatlike
seamlike14127182seamlike
soaplike1436902soaplike
toadlike1336142toadlike
wormlike1735312wormlike
alike95523963__a_like
armlike1348553_armlike
axlike17388853__axlike
baglike14338943_baglike
balmlike1655353balmlike
batlike133311883_batlike
beadlike15137253beadlike
beaklike13155773beaklike
beanlike14146843beanlike
bearlike14156793bearlike
boardlike1643313boardlike
boltlike1436313boltlike
bowlike16349473bo_wlike
bowllike1734863bowllike
boxlike20267073bo_xlike
catlike132712933_catlike
clawlike1733913clawlike
claylike1734463claylike
cocklike1536733cocklike
cokelike1336813cokelike
comblike1846293comblike
cordlike1537233cordlike
corklike1335993corklike
crablike1636023crablike
doglike13207453do_glike
domelike15177753domelike
dovelike16157133dovelike
downlike1636183downlike
dreamlike1642753dreamlike
drumlike1543793drumlike
famine114318193f_am_ine
fanglike1636823fanglike
faunlike1534763faunlike
fawnlike1844143fawnlike
feltlike1534983feltlike
fernlike1535243fernlike
finlike14279063f_inlike
fishlike18225873fishlike
flatline11298923flatline
foaling113515843foa_ling
foamable1537043foamable
foamier12339003foam_ier
foamily1546543foam_ily
foaming133612993foam_ing
foamless13195843foamless
focalise131210373focalise
focalize22139503focalize
folkie13369613fo__lkie
folklife1842963folklife
fomite113314073fo_m_ite
formalise14239783formalise
formalize232710033formalize
formulize23265623formulize
froglike1634363froglike
fumelike1735223fumelike
fuselike1535673fuselike
gamelike1538033_gamelike
gemlike14206813_gemlike
germlike1535093germlike
gnatlike1334743gnatlike
goalie7413163goa_li_e
godlike1387563go_dlike
gonglike1455423gonglike
gumlike14317403_gumlike
hatlike143311713_hatlike
hoblike16158303ho_blike
hoelike141411163ho_elike
hoglike15157733ho_glike
homelike17179533homelike
hoodlike1636563hoodlike
hooflike1834853hooflike
hooklike1435123hooklike
hooplike1736773hooplike
hornlike1536503hornlike
hoselike15179643hoselike
jawlike21116003_jawlike
lamblike1636153_lamblike
lawlike14137073_lawlike
leaflike1534713leaflike
loftlike1534393loftlike
lordlike1345813lordlike
manlike133012783_manlike
maplike15299273_maplike
moonlike1476643moonlike
mosslike1435453mosslike
mothlike1736063mothlike
nooklike1134873nooklike
noselike12158573noselike
novalike1536223novalike
owllike1435713_owllike
oxlike17307473_o_xlike
palmlike1656043palmlike
peaklike13115373peaklike
pealike131211273pea_like
playlike1735613playlike
plumlike1643793plumlike
podlike14108553po_dlike
poetlike1436733poetlike
popelike16177853popelike
potlike13910123po_tlike
quaylike2434143quaylike
rampike1536603_rampike
ratlike113912353_ratlike
raylike14269253_raylike
rocklike1335903rocklike
rodlike1288263ro_dlike
rooflike1534623rooflike
rootlike1236613rootlike
ropelike14157853ropelike
roselike12169183roselike
saclike131210123_saclike
sawlike14138443_sawlike
scablike1635553scablike
scumlike1644353scumlike
seallike12108323seallike
slablike1435673slablike
snaglike1335283snaglike
songlike1336523songlike
sonlike112110713so_nlike
soullike1236813soullike
souplike1436333souplike
sparlike1437673sparlike
starlike1238813starlike
stemlike1436723stemlike
swanlike1535313swanlike
taglike12278913_taglike
tealike111111083tea_like
toelike11149823to_elike
tomblike1645143tomblike
toylike14157243to_ylike
tramline10311383tramline
traplike1437653traplike
unalike11311533una_like
warlike142410473_warlike
waxlike21185973_waxlike
wolflike1834063wolflike
womanlike1843453womanlike
woollike1534983woollike

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.406440125.6
2DLD Change Limit1461621636.43622710.1
3Display Results1631630.0632587.3
 (SQL Overall)1786911636.90525878.5
 
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.