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

251 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
jamlike2012692(None) 
jawlike21116001jawlike
alike95523962_a_like
armlike1348552armlike
axlike17388852_axlike
baglike14338942baglike
balmlike1655352balmlike
batlike133311882batlike
beamlike16115842beamlike
catlike132712932catlike
clamlike1635162clamlike
fadlike15318482fadlike
fanlike142610502fanlike
fatlike142911192fatlike
foamlike1735142foamlike
gamelike1538032gamelike
gemlike14206812gemlike
gumlike14317402gumlike
hatlike143311712hatlike
jadelike2035992jadelike
jawline17137062jawline
jazzlike2742682jazzlike
jetlike18276762jetlike
jiglike19105332jiglike
lamblike1636152lamblike
lawlike14137072lawlike
manlike133012782manlike
maplike15299272maplike
oaklike10268002oaklike
oarlike113411192oarlike
oatlike113412402oatlike
palmlike1656042palmlike
rampike1536602rampike
ratlike113912352ratlike
raylike14269252raylike
saclike131210122saclike
sawlike14138442sawlike
seamlike14127182seamlike
taglike12278912taglike
warlike142410472warlike
waxlike21185972waxlike
airlike11310333airlike
aline57243153_a_line
alive85722513_a_live
alkie95520033_a_lkie
alsike1047913_alsike
amice96122873_am_ice
amide86128483_am_ide
amie66339853_am_i_e
amine75835383_am_ine
ammine10314493_ammine
antlike11312073antlike
apelike13310533apelike
aplite8316393_aplite
asslike1137373asslike
bailie83818363baili_e
barnlike1437183barnlike
beadlike15137253beadlike
beaklike13155773beaklike
beanlike14146843beanlike
bearlike14156793bearlike
bedlike14369533bedlike
beelike13379783beelike
belike124616283_belike
biblike1536893biblike
boatlike1457963boatlike
bowlike16349473bowlike
boxlike20267073boxlike
budlike14257873budlike
cagelike1537723cagelike
calflike1735153calflike
camellike1745063camellike
camise103319633cam_ise
cammie124615293cammi_e
carline93923613carline
cauline92215603cauline
cavelike1738213cavelike
clawlike1733913clawlike
claylike1734463claylike
comblike1846293comblike
cormlike1646703cormlike
crablike1636023crablike
cuplike1537213cuplike
dawnlike1634673dawnlike
dislike122913453dislike
doglike13207453doglike
domelike15177753domelike
dreamlike1642753dreamlike
drumlike1543793drumlike
eellike1138233eellike
elflike1435133elflike
eyelike1436973eyelike
famine114318193fam_ine
fanglike1636823fanglike
faunlike1534763faunlike
fawnlike1844143fawnlike
filmlike1734443filmlike
finlike14279063finlike
flamelike1845063flamelike
foxlike21226223foxlike
fumelike1735223fumelike
gamine94620153gam_ine
garpike1435093garpike
gatelike1337933gatelike
germlike1535093germlike
gnatlike1334743gnatlike
goadlike1435883goadlike
goatlike1346293goatlike
godlike1387563godlike
gumline102810113gumline
gutlike12308653gutlike
hairlike1536673hairlike
halide103417993ha_lide
halite93624233ha_lite
halolike1537403halolike
handlike1639153handlike
haplite12310703haplite
harelike1539613harelike
hawklike1734493hawklike
hemline12311073hemline
hemplike1936123hemplike
henlike1448693henlike
hiplike1637603hiplike
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
homelike17179533homelike
hutlike14349063hutlike
hymnlike2043123hymnlike
icelike1337173icelike
inklike1037033inklike
ivylike1734283ivylike
jadeite1546403jadeite
jailing153415843jailing
jake155925773ja___ke
jambe165314753jam__be
jambing19328533jambing
jammier18408023jammier
jammies183611293jammies
jamming19329793jamming
jasmine1636643jasmine
jawlines18126363jawlines
jimmie17376473jimmi_e
jutelike1935333jutelike
kamik105011553kam_ik_
kamiks11387913kam_iks
kaoline11310143kaoline
kidlike1137063kidlike
lacelike1438493lacelike
ladylike1634683ladylike
lakelike1137383lakelike
lambie103213673lambi_e
lamiae84817453lam_iae
lardlike1336503lardlike
lavalike1536283lavalike
leaflike1534713leaflike
leglike12136843leglike
like86040843___like
liplike1337283liplike
malice104818483ma_lice
maline84529083ma_line
mameluke1642923mameluke
mamie95826003mam_i_e
mamluk1434743mamluk_
mamluks1543313mamluks
mammie94313783mammi_e
marline93320953marline
marlite92917073marlite
masklike1335593masklike
mastlike1437863mastlike
mazelike2336463mazelike
mike105535293__m_ike
mislike132914833mislike
moatlike1446993moatlike
netlike11308913netlike
niblike1336703niblike
nunlike11258073nunlike
nutlike113110113nutlike
owllike1435713owllike
oxlike17307473_oxlike
parklike1337493parklike
peaklike13115373peaklike
pealike131211273pealike
peglike14136773peglike
piglike14157313piglike
playlike1735613playlike
plumlike1643793plumlike
podlike14108553podlike
potlike13910123potlike
pumplike1834373pumplike
puslike1347563puslike
quaylike2434143quaylike
ralline73518413ralline
ramie75027823ram_i_e
ramilie9310283ramilie
rampikes1635393rampikes
ranpike1335933ranpike
rashlike1535793rashlike
ratline74517803ratline
riblike1337333riblike
rodlike1288263rodlike
ruglike1236283ruglike
sacklike1337303sacklike
saline65132703sa_line
saltlike1237253saltlike
sambuke1544203sambuke
samite83020603sam_ite
sandlike1339713sandlike
scablike1635553scablike
scumlike1644353scumlike
seallike12108323seallike
skylike1336103skylike
slablike1435673slablike
snaglike1335283snaglike
soaplike1436903soaplike
sonlike112110713sonlike
sparlike1437673sparlike
starlike1238813starlike
stemlike1436723stemlike
sunlike112310573sunlike
swanlike1535313swanlike
tagline82412453tagline
taillike1237863taillike
talkie103914443ta_lkie
tammie104212693tammi_e
tanklike1136013tanklike
tapelike1437493tapelike
tealike111111083tealike
tinlike11248803tinlike
toadlike1336143toadlike
toelike11149823toelike
tomblike1645143tomblike
toylike14157243toylike
tramline10311383tramline
traplike1437653traplike
tublike1337083tublike
unalike11311533unalike
unlike102614063_unlike
urnlike1136713urnlike
valine94623093va_line
valise92917643va_lise
vampire14296673vampire
vaselike1536993vaselike
waiflike1834573waiflike
wallie93216803walli_e
wartlike1537043wartlike
wasplike1734893wasplike
wavelike1836613wavelike
weblike1635923weblike
wiglike15125853wiglike
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 Limit1340272517.11018850.5
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.35924282.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.