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

273 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
oaklike1026800(None) 
oarlike113411191oarlike
oatlike113412401oatlike
alike95523962_a_like
axlike17388852_axlike
baglike14338942baglike
batlike133311882batlike
beaklike13155772beaklike
boatlike1457962boatlike
catlike132712932catlike
cocklike1536732cocklike
corklike1335992corklike
fadlike15318482fadlike
fanlike142610502fanlike
fatlike142911192fatlike
foamlike1735142foamlike
folklike1434772folklike
forklike1435812forklike
goadlike1435882goadlike
goatlike1346292goatlike
hatlike143311712hatlike
hawklike1734492hawklike
hooklike1435122hooklike
inklike1037032inklike
jamlike20126922jamlike
jawlike21116002jawlike
lakelike1137382lakelike
lawlike14137072lawlike
manlike133012782manlike
maplike15299272maplike
masklike1335592masklike
moatlike1446992moatlike
nooklike1134872nooklike
owllike1435712owllike
oxlike17307472o_xlike
parklike1337482parklike
peaklike13115372peaklike
ratlike113912352ratlike
raylike14269252raylike
rocklike1335902rocklike
sacklike1337302sacklike
saclike131210122saclike
sawlike14138442sawlike
soaplike1436902soaplike
taglike12278912taglike
tanklike1136012tanklike
toadlike1336142toadlike
warlike142410472warlike
waxlike21185972waxlike
airlike11310333airlike
aline57243153_a_line
alive85722513_a_live
alkie95520033_alki_e
alkine104916803_alkine
alsike1047913_alsike
antlike11312073antlike
apelike13310533apelike
aplite8316393_aplite
armlike1348553armlike
asslike1137373asslike
bailie83818363baili_e
bakelite1447253bakelite
balkline1437973balkline
balmlike1655353balmlike
barnlike1437183barnlike
beadlike15137253beadlike
beamlike16115843beamlike
beanlike14146843beanlike
bearlike14156793bearlike
bedlike14369533bedlike
beelike13379783beelike
belike124616283_belike
biblike1536893biblike
boardlike1643313boardlike
boltlike1436313boltlike
booklice1644753booklice
bowlike16349473bowlike
bowllike1734863bowllike
boxlike20267073boxlike
brooklike1453273brooklike
budlike14257873budlike
cagelike1537723cagelike
calflike1735153calflike
carline93923613carline
cauline92215603cauline
cavelike1738213cavelike
clamlike1635163clamlike
clawlike1733913clawlike
claylike1734463claylike
clocklike1642823clocklike
cokelike1336813cokelike
comblike1846293comblike
cordlike1537233cordlike
cormlike1646703cormlike
crablike1636023crablike
cuplike1537213cuplike
dawnlike1634673dawnlike
disklike12206743disklike
dislike122913453dislike
doglike13207453doglike
domelike15177753domelike
dovelike16157133dovelike
downlike1636183downlike
eellike1138233eellike
elflike1435133elflike
eyelike1436973eyelike
fanglike1636823fanglike
faunlike1534763faunlike
fawnlike1844143fawnlike
finlike14279063finlike
folklife1842963folklife
footlike1537253footlike
foxlike21226223foxlike
gamelike1538033gamelike
garpike1435093garpike
gatelike1337933gatelike
gemlike14206813gemlike
gnatlike1334743gnatlike
goalie7413153goa_li_e
godlike1387563godlike
gonglike1455423gonglike
gumlike14317403gumlike
gutlike12308653gutlike
hairlike1536673hairlike
halide103417993ha_lide
halite93624233ha_lite
halolike1537403halolike
handlike1639153handlike
haplite12310703haplite
harelike1539613harelike
henlike1448693henlike
hiplike1637603hiplike
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
homelike17179533homelike
hoodlike1636563hoodlike
hooflike1834853hooflike
hooplike1736773hooplike
hornlike1536503hornlike
hoselike15179643hoselike
husklike1433613husklike
hutlike14349063hutlike
icelike1337173icelike
ivylike1734283ivylike
jadelike2035993jadelike
jawline17137063jawline
jazzlike2742683jazzlike
jetlike18276763jetlike
jiglike19105333jiglike
kaoline11310143kaoline
khakilike1441233khakilike
kidlike1137063kidlike
kike76524783__k_ike
klik74412653__klik_
kliks8398823__kliks
lacelike1438493lacelike
ladylike1634683ladylike
lamblike1636153lamblike
lardlike1336503lardlike
lavalike1536283lavalike
leaflike1534713leaflike
leglike12136843leglike
like86040843___like
liplike1337283liplike
loftlike1534393loftlike
lookalike1242493lookalike
lordlike1345813lordlike
malice104818483ma_lice
maline84529083ma_line
marline93320953marline
marlite92917073marlite
mastlike1437863mastlike
mazelike2336463mazelike
mislike132914833mislike
moonlike1476643moonlike
mosslike1435453mosslike
mothlike1736063mothlike
necklike13104563necklike
netlike11308913netlike
niblike1336703niblike
noselike12158573noselike
novalike1536223novalike
nunlike11258073nunlike
nutlike113110113nutlike
oakier104011393oak_ier
oatcake1345363oatcake
obelise9310173obelise
obelize1838243obelize
oblige937653o_blige
offline1345783offline
olive84817153o__live
online6315843o_nline
oolite63319603o_olite
opaline9412483opaline
outlie62419523outli_e
outline72321333outline
outlive102513033outlive
ovenlike1535013ovenlike
palmlike1656043palmlike
pealike131211273pealike
peglike14136773peglike
piglike14157313piglike
playlike1735613playlike
podlike14108553podlike
poetlike1436733poetlike
popelike16177853popelike
potlike13910123potlike
puslike1347563puslike
quaylike2434143quaylike
ralline73518413ralline
rampike1536603rampike
ranpike1335933ranpike
rashlike1535793rashlike
ratline74517803ratline
riblike1337333riblike
rodlike1288263rodlike
rooflike1534623rooflike
rootlike1236613rootlike
ropelike14157853ropelike
roselike12169183roselike
ruglike1236283ruglike
saline65132703sa_line
saltlike1237253saltlike
sandlike1339713sandlike
scablike1635553scablike
seallike12108323seallike
seamlike14127183seamlike
sharklike1543923sharklike
silklike1135523silklike
skylike1336103skylike
slablike1435673slablike
snaglike1335283snaglike
snakelike1244293snakelike
songlike1336523songlike
sonlike112110713sonlike
soullike1236813soullike
souplike1436333souplike
sparlike1437663sparlike
stalklike1243903stalklike
starlike1238813starlike
sunlike112310573sunlike
swanlike1535313swanlike
tagline82412453tagline
taillike1237863taillike
talkie103914443talki_e
tapelike1437493tapelike
tealike111111083tealike
tinlike11248803tinlike
toelike11149823toelike
tomblike1645143tomblike
toylike14157243toylike
traplike1437653traplike
tublike1337083tublike
tusklike1133583tusklike
unalike11311533unalike
unlike102614063_unlike
urnlike1136713urnlike
valine94623093va_line
valise92917643va_lise
vaselike1536993vaselike
waiflike1834573waiflike
wakiki1233463wak_iki
wallie93216803walli_e
wartlike1537043wartlike
wasplike1734893wasplike
wavelike1836613wavelike
weblike1635923weblike
wiglike15125853wiglike
wolflike1834063wolflike
womanlike1843453womanlike
woollike1534983woollike
wormlike1735313wormlike

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272737.09618887.7
3Display Results2732730.1062575.5
 (SQL Overall)1786912737.35824285.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.