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

145 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
crablike163602(None) 
catlike132712932c_atlike
clamlike1635162clamlike
clawlike1733912clawlike
claylike1734462claylike
comblike1846292comblike
crabwise1543612crabwise
crapelike1744932crapelike
ratlike113912352_ratlike
raylike14269252_raylike
riblike1337332_riblike
scablike1635552scablike
slablike1435672slablike
traplike1437652traplike
alike95523963__a_like
arabize1849343arab_ize
arable81821003arabl__e
armlike1348553ar_mlike
axlike17388853__axlike
baglike14338943_baglike
barnlike1437183barnlike
batlike133311883_batlike
beadlike15137253beadlike
beaklike13155773beaklike
beamlike16115843beamlike
beanlike14146843beanlike
bearlike14156793bearlike
biblike1536893_biblike
boatlike1457963boatlike
brawlie12198153brawli_e
cabbie122913353c_abbi_e
cable95329913c_abl__e
cabling124017553c_abling
cagelike1537723cagelike
calflike1735153calflike
carabine12412393carab_ine
carbide126112493carb_ide
carbine112918643carb_ine
carbolize22189173carbolize
carline93923613c_arline
cauline92215603c_auline
cavelike1738213cavelike
chablis14368563chabli_s
chalice14311043cha_lice
challie124012853challi_e
charlie123011923charli_e
cherublike2151243cherublike
cigarlike1642333cigarlike
cocklike1536733cocklike
cokelike1336813cokelike
coralline1147943coralline
cordlike1537233cordlike
corklike1335993corklike
cormlike1646703cormlike
craaling112711353craaling
crabbier14326803crabbier
crabbily1744343crabbily
crabbing15287933crabbing
cradle93313163cradl__e
cradling122411453cradling
crake114823523cra___ke
crappie13298983crappi_e
craterlike1644013craterlike
crawlier13216873crawlier
crawling143110513crawling
creolise1037863creolise
creolize1947183creolize
cryolite1347503cryolite
cultlike1434933cultlike
cuplike1537213c_uplike
curable112414513curabl__e
dragline1036843dragline
dreamlike1642753dreamlike
drumlike1543793drumlike
fadlike15318483_fadlike
fanlike142610503_fanlike
fatlike142911193_fatlike
foamlike1735143foamlike
froglike1634363froglike
gnatlike1334743gnatlike
goadlike1435883goadlike
goatlike1346293goatlike
grapelike1644663grapelike
grapline1138723grapline
grasslike1443693grasslike
gravelike1744513gravelike
harelike1539613harelike
hatlike143311713_hatlike
herblike1735883herblike
hoblike16158303_hoblike
ironlike1235713ironlike
jamlike20126923_jamlike
jawlike21116003_jawlike
knoblike1343163knoblike
lamblike1636153lamblike
lardlike1336503lardlike
lawlike14137073_lawlike
leaflike1534713leaflike
manlike133012783_manlike
maplike15299273_maplike
moatlike1446993moatlike
niblike1336703_niblike
oaklike10268003_oaklike
oarlike113411193_oarlike
oatlike113412403_oatlike
parklike1337493parklike
peaklike13115373peaklike
pealike131211273pea_like
playlike1735613playlike
praline93019743pra_line
quaylike2434143quaylike
ralline73518413_ralline
rampike1536603_rampike
ranpike1335933_ranpike
rashlike1535793_rashlike
ratline74517803_ratline
rodlike1288263_rodlike
rubylike1753353_rubylike
ruglike1236283_ruglike
saclike131210123_saclike
sawlike14138443_sawlike
screwlike1843303screwlike
seallike12108323seallike
seamlike14127183seamlike
shrublike1842713shrublike
snaglike1335283snaglike
soaplike1436903soaplike
sparlike1437673sparlike
starlike1238813starlike
swanlike1535313swanlike
taglike12278913_taglike
tealike111111083tea_like
toadlike1336143toadlike
tomblike1645143tomblike
tramline10311383tramline
trapline10411863trapline
treelike1237003treelike
tublike1337083_tublike
unalike11311533una_like
uralite71714103ura_lite
urnlike1136713ur_nlike
warlike142410473_warlike
wartlike1537043wartlike
waxlike21185973_waxlike
weblike1635923_weblike

Search took 9 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 Limit1461621457.98318309.2
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.46921099.4
 
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.