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

166 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
beaklike1315577(None) 
beadlike15137251beadlike
beamlike16115841beamlike
beanlike14146841beanlike
bearlike14156791bearlike
peaklike13115371peaklike
baglike14338942b_aglike
batlike133311882b_atlike
bedlike14369532be_dlike
beelike13379782be_elike
belike124616282be__like
boatlike1457962boatlike
leaflike1534712leaflike
necklike13104562necklike
oaklike10268002_oaklike
pealike131211272pea_like
seallike12108322seallike
seamlike14127182seamlike
tealike111111082tea_like
alike95523963__a_like
axlike17388853__axlike
bailie83818363b_aili_e
bakelite1447253b_akelite
balkline1437973balkline
balmlike1655353balmlike
barnlike1437183barnlike
beadle93314683beadl__e
beagle93612593beagl__e
beakier134012163beak_ier
beakless14297383beakless
beanie83618593bea_ni_e
beastie92412433beasti_e
beatnik1344863beatnik_
beatniks1444043beatniks
beeline93314723be_eline
belie75630383be__li_e
belive115415303be__live
bellylike1842843bellylike
beltline1036943beltline
berline93716853be_rline
berrylike1842353berrylike
beryline1337083beryline
beslime1146833be_slime
beylik1545883be_ylik_
beyliks1634853be_yliks
biblike1536893b_iblike
birdlike1535233birdlike
bladelike1643833bladelike
boardlike1643313boardlike
boltlike1436313boltlike
booklice1644753booklice
bowlike16349473b_owlike
bowllike1734863bowllike
boxlike20267073b_oxlike
brawlie12198153brawli_e
breadline1246273breadline
bricklike1643113bricklike
brooklike1453273brooklike
budlike14257873b_udlike
bushlike1734963bushlike
catlike132712933_catlike
clamlike1635163clamlike
clawlike1733913clawlike
claylike1734463claylike
cocklike1536733cocklike
corklike1335993corklike
crablike1636023crablike
deadline10139053deadline
deathlike1753823deathlike
deerlike1335723deerlike
disklike12206743disklike
dreamlike1642753dreamlike
eellike1138233_eellike
elflike1435133_elflike
eyelike1436973_eyelike
fadlike15318483_fadlike
fanlike142610503_fanlike
fatlike142911193_fatlike
feltlike1534983feltlike
fernlike1535243fernlike
foamlike1735143foamlike
folklike1434773folklike
forklike1435813forklike
gemlike14206813ge_mlike
germlike1535093germlike
gnatlike1334743gnatlike
goadlike1435883goadlike
goatlike1346293goatlike
hatlike143311713_hatlike
hawklike1734493hawklike
headline12129613headline
heathlike1944323heathlike
hemplike1936123hemplike
henlike1448693he_nlike
herblike1735883herblike
herdlike1636113herdlike
hooklike1435123hooklike
husklike1433613husklike
inklike1037033_inklike
jamlike20126923_jamlike
jawlike21116003_jawlike
jetlike18276763je_tlike
khakilike1441233khakilike
lakelike1137383_lakelike
lawlike14137073_lawlike
leglike12136843le_glike
manlike133012783_manlike
maplike15299273_maplike
masklike1335593masklike
mealie82519813mea_li_e
metallike1555893metallike
moatlike1446993moatlike
neckline1496363neckline
nestlike1236083nestlike
netlike11308913ne_tlike
nooklike1134873nooklike
oarlike113411193_oarlike
oatlike113412403_oatlike
parklike1337493parklike
pearlite1039443pearlite
peglike14136773pe_glike
petallike1554633petallike
playlike1735613playlike
quaylike2434143quaylike
ratlike113912353_ratlike
raylike14269253_raylike
realise73021813rea_lise
realize162717083rea_lize
reedlike1336213reedlike
rocklike1335903rocklike
sacklike1337303sacklike
saclike131210123_saclike
sawlike14138443_sawlike
scablike1635553scablike
seedlike1335993seedlike
serflike1536273serflike
sharklike1543933sharklike
sheaflike1942973sheaflike
silklike1135523silklike
slablike1435673slablike
snaglike1335283snaglike
snakelike1244293snakelike
soaplike1436903soaplike
sparlike1437673sparlike
spearlike1544143spearlike
stalklike1243903stalklike
starlike1238813starlike
swanlike1535313swanlike
taglike12278913_taglike
tanklike1136013tanklike
tentlike1236903tentlike
toadlike1336143toadlike
traplike1437653traplike
tusklike1133583tusklike
unalike11311533una_like
veillike1534603veillike
veinlike1534313veinlike
vestlike1535393vestlike
warlike142410473_warlike
waxlike21185973_waxlike
weaklier1534263weaklier
weakling16106763weakling
weakside1642843weakside
weblike1635923we_blike
weedlike1634393weedlike
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.406440125.6
2DLD Change Limit1461621667.39019778.3
3Display Results1661660.0802075.0
 (SQL Overall)1786911667.87622688.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.