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

411 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
jammies18361129(None) 
cammies134016481cammies
jammier18408021jammier
jammiest19307201jammiest
jemmies18318331jemmies
jimmies18328781jimmies
mammies104314761mammies
tammies113814681tammies
amies76837692_a_mies
ammines11312672_ammines
armies85123692_armies
cammie124615292cammie_
chammies172910162chammies
commies133718452commies
dummies123012132dummies
gammier123711192gammier
gammiest13339332gammiest
gimmies123010112gimmies
hammier143510652hammier
hammiest152610012hammiest
immies102412442_immies
jackies202912622jackies
jaggies163311082jaggies
jambes175914052ja_mbes
jammed183811502jamm_ed
jammer174014132jamm_er
jammers183710702jammers
jamming19329792jamming
jasmines1736622jasmines
jasmins1637082jasmins
jemmied19294482jemmied
jimmie17376472jimmie_
jimmied19275032jimmied
lambies113015112lambies
mamies104626242ma_mies
mammees104411142mammees
mammie94313782mammie_
mommies103912272mommies
mummies103812842mummies
pommies133712842pommies
ramies84630462ra_mies
rammier112811022rammier
rammiest12299932rammiest
rummies113212792rummies
shammies15259692shammies
tammie104212692tammie_
tommies113812982tommies
tummies113012032tummies
whammies18265512whammies
yummies14359532yummies
acmes96020653_acm_es
admires1038663_admires
admits9411413_admits
admixes1765963_admixes
aeries64737783_aeries
aggies83515513_aggies
alkies104518093_alkies
allies63827673_allies
almes75126543_alm_es
amazes175613473_amazes
ambits103713413_ambits
ambles105121863_ambles
ambries111614553_ambries
amias75831473_a_mias
amices105018013_amices
amides95722663_amides
amids85627513_a_mids
amie66339853_a_mie_
amines84727983_amines
amins75534323_a_mins
amirs75924923_a_mirs
amis66445323_a_mi_s
amiss75823073_a_miss
amities9317383_amities
ammine10314493_ammine
ammino1069883_ammino
ammos94815823_amm_os
amnios84912523_amnios
amoles84122193_amoles
amuses85117943_amuses
animes84719593_animes
anomies93316993anomies
atomies93918363atomies
babies106123653ba_bies
baddies114017873baddies
baffies153612943baffies
baggies113814853baggies
bailies94120203bailies
baldies105317703baldies
ballies93725743ballies
balmier113811513balmier
balmiest124110993balmiest
bammed133913243bamm_ed
bamming144611813bamming
bandies104124863bandies
banties94324763banties
barbies114519593barbies
barmie103816393barmie_
barmier114313043barmier
barmiest125212783barmiest
bawdies134613393bawdies
bawties124214313bawties
cabbies133115163cabbies
caddies113718383caddies
camails11311753camails
camases114216343camases
cames97047313ca_m_es
camise103319633ca_mise
camises114218463camises
camomiles15155633camomiles
campier133313273campier
campiest142212143campiest
candies104125613candies
caries85147623ca_ries
carmines123617873carmines
carnies94123963carnies
carries94328013carries
catties94023053catties
cavies114525003ca_vies
chammied18215973chammied
clammier1435843clammier
clammiest1535743clammiest
commie124215523commie_
commits133812383commits
commixes2177353commixes
crummies1437643crummies
cummins1358963cummins
daddies103414943daddies
dailies84219263dailies
daimios1035753daimios
dairies84217733dairies
daisies84217093daisies
dallies84023193dallies
damages11511283damages
dames85435853da_m_es
dammars12308193dammars
dammed124214793damm_ed
dammer114317933damm_er
dammers123214273dammers
damming133812743damming
dammit11311133dammi_t
dandies94121443dandies
darbies104216983darbies
darkies124015753darkies
dassies84418663dassies
dauties83315763dauties
davies105020513da_vies
dawties113312703dawties
demies94825803_demies
dummied13346723dummied
easies64126633ea_sies
enemies9313693enemies
facies113921593fa_cies
faeries104118993faeries
fairies103516043fairies
falsies103515013falsies
fames105735923fa_m_es
families1339443families
famines123216263famines
fancies124018783fancies
fannies103415643fannies
farcies125317883farcies
fatties103018203fatties
femmes135410213femm_es
gabies93820733ga_bies
gallies84122713gallies
gambes116318313ga_mbes
gambias125010733gambias
gambier124711973gambier
gambiers13337073gambiers
gambirs12359083gambirs
gambits12399723gambits
gambles124016203gambles
games86238553ga_m_es
gametes10312253gametes
gamier93617933ga_mier
gamiest102816233ga_miest
gamines103618463gamines
gamins94420053ga_mins
gammas115714693gamm_as
gammed124216163gamm_ed
gammer1112318333gamm_er
gammers123214563gammers
gamming133112623gamming
gammons1237973gammons
gaudies9311973gaudies
gawkies15429123gawkies
gemmier12337383gemmier
gemmiest13227633gemmiest
gimmes113010903gimm_es
gimmie11298183gimmie_
grammes123611323gramm_es
gremmies1355993gremmies
gummier12349473gummier
gummiest13269033gummiest
gummites1346173gummites
hackies163418243hackies
haemins122811403haemins
hamates122917683hamates
hames106138703ha_m_es
hammals14409223hammals
hammams13386443hammams
hammed144116973hamm_ed
hammer138120033hamm_er
hammers144216063hammers
hammily1736063hammily
hamminess1635713hamminess
hamming153014093hamming
hankies143617763hankies
hardies114923233hardies
harmines132715143harmines
harmins123716723harmins
harpies123818323harpies
harries103525493harries
hawkies173311243hawkies
homies114524723_homies
iambics13425643iambics
immixes1835073_immixes
jacales16310323jacales
jadeites1645823jadeites
jades135222113ja__des
jaggier16339183jaggier
jaggiest17289323jaggiest
jails125422943ja__ils
jakes165023643ja__kes
jalopies1786673jalopies
jambe165314753ja_mbe_
jambed184811403ja_mbed
jambing19328533jambing
jambs166014623ja_m_bs
jamlike20126923jamlike
jammy194810193jamm__y
jams135231073ja_m__s
janes124928123ja__nes
jangles154015683jangles
japeries17311463japeries
japes146322823ja__pes
jasmin1538073jasmi_n
jasmine1636643jasmine
jassids1586143jassids
jaunces16307423jaunces
jawlines18126363jawlines
jaygees1854513jaygees
jayvees2052923jayvees
jazzes21347883ja_zzes
jazzier2233883jazzier
jazziest2333813jazziest
jellies143816533jellies
jennies143511623jennies
jerkies183411583jerkies
jerries143817513jerries
jetties143613123jetties
jiffies20327473jiffies
jimminy2133373jimminy
jollies143516273jollies
jumbles183013323jumbles
jumpier18317943jumpier
jumpiest1936863jumpiest
junkies183711693junkies
juries134120633j_uries
jutties143814003jutties
kalmias1347973kalmias
kames115024693ka_m_es
kamiks11387913ka_miks
kamsins1346963kamsins
kauries113613193kauries
laddies93715053laddies
ladies75124883la_dies
laities7320343laities
lambie103213673lambie_
lambier113611643lambier
lambiest122410193lambiest
lames75445543la_m_es
lamias85020613la_mias
lammed113915623lamm_ed
lamming123014583lamming
lassies74420103lassies
lazies154418783la_zies
magpies12310363magpies
malmier113611953malmier
malmiest123211023malmiest
mamboes135011823mamboes
mameyes14376983mameyes
mamie95826003ma_mie_
mammae94613213mammae_
mammals10389273mammals
mammas94616403mamm_as
mammee94417853mamm_ee
mammer94218863mamm_er
mammers104615693mammers
mammet94319253mamm_et
mammets103911113mammets
mammey124310893mamm_ey
mammeys13376723mammeys
mammitis1145593mammitis
mammons1048513mammons
marmites122212793marmites
marries93825283marries
mashies12318253mashies
mavies114923193ma_vies
mimes95732023__mimes
mummied11327103mummied
names74833363na_m_es
nancies93516843nancies
nannies73015203nannies
nappies114613403nappies
nasties73520493nasties
navies95218623na_vies
navvies1335323navvies
paddies113715723paddies
palmier113312173palmier
palmiest123212033palmiest
palsies94420273palsies
pandies104224503pandies
panmixes1934913panmixes
pansies94521983pansies
panties94230933panties
pappies103214833pappies
paries84742513pa_ries
parries93925843parries
parties93230863parties
pasties94529813pasties
patsies93919483patsies
patties93425143patties
pigmies122610993pigmies
pommie123710503pommie_
premies113823063premies
psammites1542843psammites
pygmies15205673pygmies
rabbies113416053rabbies
rabies85226023ra_bies
raggies93214733raggies
rallies73823343rallies
rambles113118313rambles
ramees84620893ra_mees
ramie75027823ra_mie_
ramifies13310503ramifies
ramilies10311833ramilies
rammed113117303ramm_ed
rammer103519653ramm_er
rammers113715043rammers
ramming123115063ramming
rammish1437563rammish
rampikes1635393rampikes
ramtils938413ramtils
randies84225663randies
roomies93017243roomies
rummier11309563rummier
rummiest12299353rummiest
saimins9312113saimins
sallies73227813sallies
salmis8514273salmi_s
salties73725773salties
samiel8313333sa_miel
samiels939763sa_miels
samites93118713samites
samples112815453samples
sanies63031953sa_nies
sassies74719263sassies
sauries72821623sauries
savvies1337603savvies
scampies1439333scampies
shammes144312833shamm_es
shammied16265543shammied
shimmies15287803shimmies
stimies9316563stimies
stymies1239213stymies
summits1137983summits
swamies123712063swamies
tabbies112913503tabbies
taffies133012693taffies
talkies113415733talkies
tallies73624603tallies
tamales93216153tamales
tameins9311423tameins
tames75242013ta_m_es
tamis76728733ta_mi_s
tamises92715973tamises
tansies74521243tansies
tardies84225863tardies
tarries73324263tarries
tassies74918933tassies
tatties74120343tatties
tawnies102812503tawnies
tawpies12309873tawpies
taxies135817333ta_xies
umamis1038273umami_s
vamoses1239143vamoses
vampier14308233vampier
vampiest15237653vampiest
vampires15226033vampires
varies94330873va_ries
waddies124214753waddies
wadies105121203wa_dies
waffies163611443waffies
walies95324523wa_lies
wallies103320743wallies
wambles143714023wambles
wames106432803wa_m_es
wammus13426733wamm_us
wammuses1543493wammuses
wamuses1237023wamuses
wavies125019843wa_vies
yabbies14279643yabbies
yammer133713183yamm_er
yammers143410323yammers
yummier14306843yummier
yummiest15256723yummiest
zamias174212923za_mias
zanies153219673za_nies
zombies2037993zombies

Search took 7 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.420425454.8
2DLD Change Limit1340274115.98622390.1
3Display Results4114110.1562634.6
 (SQL Overall)1786914116.56227231.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.