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

201 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
soaplike143690(None) 
souplike1436331souplike
boatlike1457962boatlike
foamlike1735142foamlike
goadlike1435882goadlike
goatlike1346292goatlike
hooplike1736772hooplike
maplike15299272_maplike
moatlike1446992moatlike
oaklike10268002_oaklike
oarlike113411192_oarlike
oatlike113412402_oatlike
saclike131210122s_aclike
sawlike14138442s_awlike
scablike1635552scablike
seallike12108322seallike
seamlike14127182seamlike
slablike1435672slablike
snaglike1335282snaglike
songlike1336522songlike
sonlike112110712so_nlike
soullike1236812soullike
sparlike1437672sparlike
starlike1238812starlike
steplike1436732steplike
swanlike1535312swanlike
toadlike1336142toadlike
traplike1437652traplike
alike95523963__a_like
apelike13310533__apelike
aplite8316393__aplite
axlike17388853__axlike
baglike14338943_baglike
batlike133311883_batlike
beadlike15137253beadlike
beaklike13155773beaklike
beamlike16115843beamlike
beanlike14146843beanlike
bearlike14156793bearlike
boardlike1643313boardlike
boltlike1436313boltlike
bowlike16349473bo_wlike
bowllike1734863bowllike
boxlike20267073bo_xlike
catlike132712933_catlike
clamlike1635163clamlike
clawlike1733913clawlike
claylike1734463claylike
cocklike1536733cocklike
cokelike1336813cokelike
comblike1846293comblike
complice1639333complice
compline14313553compline
cordlike1537233cordlike
corklike1335993corklike
cormlike1646703cormlike
crablike1636023crablike
crapelike1744933crapelike
cuplike1537213_cuplike
doglike13207453do_glike
domelike15177753domelike
dovelike16157133dovelike
downlike1636183downlike
fadlike15318483_fadlike
fanlike142610503_fanlike
fatlike142911193_fatlike
folklike1434773folklike
footlike1537253footlike
forklike1435813forklike
foxlike21226223fo_xlike
gnatlike1334743gnatlike
goalie7413163goa_li_e
godlike1387563go_dlike
gonglike1455423gonglike
grapelike1644663grapelike
grapline1138723grapline
haplite12310703_haplite
hatlike143311713_hatlike
hemplike1936123hemplike
hiplike1637603_hiplike
hoblike16158303ho_blike
hoelike141411163ho_elike
hoglike15157733ho_glike
homelike17179533homelike
hoodlike1636563hoodlike
hooflike1834853hooflike
hooklike1435123hooklike
hoplite12311073ho_plite
hornlike1536503hornlike
hoselike15179643hoselike
jamlike20126923_jamlike
jawlike21116003_jawlike
lawlike14137073_lawlike
leaflike1534713leaflike
liplike1337283_liplike
loftlike1534393loftlike
lordlike1345813lordlike
manlike133012783_manlike
moonlike1476643moonlike
mosslike1435453mosslike
mothlike1736063mothlike
nooklike1134873nooklike
noselike12158573noselike
novalike1536223novalike
opaline9412483_opaline
owllike1435713_owllike
oxlike17307473_o_xlike
peaklike13115373peaklike
pealike131211273pea_like
playlike1735613playlike
podlike14108553po_dlike
poetlike1436733poetlike
popelike16177853popelike
potlike13910123po_tlike
pumplike1834373pumplike
quaylike2434143quaylike
ratlike113912353_ratlike
raylike14269253_raylike
rocklike1335903rocklike
rodlike1288263ro_dlike
rooflike1534623rooflike
rootlike1236613rootlike
ropelike14157853ropelike
roselike12169183roselike
sacklike1337303sacklike
saline65132703s_a_line
saltlike1237253saltlike
sandlike1339713sandlike
sapling103217863s_apling
scalelike1545253scalelike
scapolite1346243scapolite
scumlike1644353scumlike
seaplane1049163seaplane
seedlike1335993seedlike
semplice1447013semplice
sepaline10311343sepaline
serflike1536273serflike
shalelike1645883shalelike
sharklike1543933sharklike
shaslik1444513shaslik_
shasliks1544143shasliks
sheaflike1942973sheaflike
shedlike1635833shedlike
sighlike1635533sighlike
silklike1135523silklike
skinlike1134873skinlike
skylike1336103s_kylike
slatelike1346153slatelike
sleeplike1543463sleeplike
slitlike1235303slitlike
smokelike1443493smokelike
snaillike1343773snaillike
snakelike1244293snakelike
snowlike1534973snowlike
soapier93411713soap_ier
soapily1237963soap_ily
soaping103616223soap_ing
soapless10278073soapless
sodalite9109593sodalite
sopite84917713so_p_ite
sorptive1346473sorptive
souslik1144153souslik_
sousliks1244003sousliks
spearlike1544143spearlike
spike114922843s__p_ike
splake1259783s__plake
splice104915103s__plice
spline86020533s__pline
stagelike1445343stagelike
stairlike1344753stairlike
stalklike1243903stalklike
staple84415823stapl__e
stapling112813153stapling
stemlike1436723stemlike
suchlike1735123suchlike
sugarlike1443243sugarlike
suitlike1236313suitlike
sunlike112310573s_unlike
surflike1535933surflike
surplice1246203surplice
swordlike1742713swordlike
sylphlike2142683sylphlike
syruplike1842233syruplike
taglike12278913_taglike
tapelike1437493_tapelike
tealike111111083tea_like
toelike11149823to_elike
tomblike1645143tomblike
topline92313183to_pline
toylike14157243to_ylike
trapline10411863trapline
unalike11311533una_like
warlike142410473_warlike
wasplike1734893wasplike
waxlike21185973_waxlike
whiplike2043813whiplike
wisplike1734713wisplike
wolflike1834063wolflike
womanlike1843453womanlike
woollike1534983woollike
wormlike1735313wormlike

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.440406115.9
2DLD Change Limit1461622017.96618348.2
3Display Results2012010.0802512.5
 (SQL Overall)1786912018.48621057.2
 
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.