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

304 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
jemmies1831833(None) 
jammies183611291jammies
jemmied19294481jemmied
jimmies18328781jimmies
cammies134016482cammies
commies133718452commies
demies94825802de_mies
dummies123012132dummies
femmes135410212femm_es
gemmier12337382gemmier
gemmiest13227632gemmiest
gimmies123010112gimmies
gremmies1355992gremmies
immies102412442_immies
jammier18408022jammier
jammiest19307202jammiest
jellies143816532jellies
jennies143511622jennies
jerkies183411582jerkies
jerries143817512jerries
jetties143613122jetties
jimmie17376472jimmie_
jimmied19275032jimmied
mammies104314762mammies
mommies103912272mommies
mummies103812842mummies
pommies133712842pommies
rummies113212792rummies
tammies113814682tammies
tommies113812982tommies
tummies113012032tummies
yummies14359532yummies
aeries64737783ae_ries
amies76837693__amies
ammines11312673_ammines
anomies93316993anomies
armies85123693_armies
atomies93918363atomies
beamier113411943beamier
beamiest123212763beamiest
beanies93821093beanies
beedies10314203beedies
belies84631053be_lies
bellies94023723bellies
bemires113212833bemires
bemixes18338653bemixes
bemuses1139293bemuses
bennies93917313bennies
berimes115216643berimes
bermes106023003berm_es
berries94423553berries
besmiles1237393besmiles
betimes115114413betimes
bevies114017303be_vies
cammie124615293cammie_
chammies172910163chammies
commie124215523commie_
commits133812383commits
commixes2177353commixes
crummies1437643crummies
cummins1358963cummins
dearies83526273dearies
decries103319803decries
defies104624053de_fies
deifies113317453deifies
deities82621923deities
delimes10314193delimes
dellies83622213dellies
demes86032693de_m_es
demise94618323de_mise
demises103719563demises
demits94918073de_mits
demoses103815823demoses
demotes104717673demotes
denies74729643de_nies
derbies103016053derbies
dermis94717163dermi_s
dermises112512023dermises
derries83124623derries
desmids1166603desmids
dexies145018343de_xies
dummied13346723dummied
easies64126633_easies
eddies83313163_eddies
elmier839813_elmier
elmiest9310743_elmiest
emails84412343_emails
emcees1037813_emcees
emeries91620023_emeries
emes65434663_e_m_es
emeses86114963_emeses
emirs76116163_e_mirs
emits75421473_e_mits
emmer94314463_emm_er
emmers104013223_emmers
emmet94221383_emm_et
emmets10349153_emmets
emmys12446023_emm_ys
emotes84620283_emotes
empires1139853_empires
empties11712243_empties
emydes1236173_emydes
enemies9313693enemies
envies9314053_envies
ermines9416673_ermines
espies83716803_espies
eyries93816813_eyries
fellies104119743fellies
females12310663females
femes105626223fe_m_es
femme125011433femm_e_
ferlies103216693ferlies
fermis114313503fermi_s
ferries103521083ferries
gammier123711193gammier
gammiest13339333gammiest
gemmae11507793gemmae_
gemmates13307673gemmates
gemmed12329573gemm_ed
gemmily1534603gemmily
gemminess1464643gemminess
gemming13289153gemming
gemmules13183213gemmules
gemotes103712143gemotes
genies75324943ge_nies
germier10309543germier
germiest11249923germiest
gimmes113010903gimm_es
gimmie11298183gimmie_
gremmie1264383gremmie_
gummier12349473gummier
gummiest13269033gummiest
gummites1346173gummites
hammier143510653hammier
hammiest152610013hammiest
heavies132713873heavies
heinies102514543heinies
hemes105031083he_m_es
hemins113417573he_mins
hemlines13310623hemlines
hemmed144211463hemm_ed
hemmer134112643hemm_er
hemmers143310843hemmers
hemming15269973hemming
hempie132410563hempie_
hempier14319003hempier
hempiest1539043hempiest
henries102718283henries
hermits12312143hermits
herries104025073herries
homies114524723_homies
immixes1835073_immixes
jackies202912623jackies
jaggies163311083jaggies
jambes175914053j_ambes
jammed183811503jamm_ed
jammer174014133jamm_er
jammers183710703jammers
jamming19329793jamming
jasmines1736623jasmines
jasmins1637083jasmins
jees115938543je___es
jefes155613673je__fes
jellied15419223jellied
jemmy19498553jemm__y
jemmying2332313jemmying
jerids142810943je_rids
jerkier18407273jerkier
jerkiest19328113jerkiest
jerkins18358253jerkins
jerrids15277743jerrids
jesses135215953je_sses
jesuits1436323jesuits
jetes124922843je__tes
jettied15366973jettied
jettier14358693jettier
jettiest15359593jettiest
jezails2334163jezails
jiffies20327473jiffies
jimminy2133373jimminy
jollies143516273jollies
jumbles183013323jumbles
jumpier18317943jumpier
jumpiest1936863jumpiest
junkies183711693junkies
juries134120633j_uries
jutties143814003jutties
kebbies1537253kebbies
kellies113516853kellies
kelpies13289903kelpies
kermes124616133kerm_es
kermis124012393kermi_s
kermises14248313kermises
kerries113317913kerries
kewpies16246923kewpies
lambies113015113lambies
lefties10312073lefties
lemmas10349163lemm_as
lemming12269393lemming
lemmings13254733lemmings
lemures938793lemures
levies93919863le_vies
lezzies1536203lezzies
mamies104626243_mamies
mammees104411143mammees
mammie94313783mammie_
mealies92821933mealies
meanies93620743meanies
meinies92516073meinies
memes94927703me_m_es
memoirs1136803memoirs
memories121214353memories
mercies113817563mercies
mimes95732023__mimes
mummied11327103mummied
neddies92710703neddies
nellies73418723nellies
nemeses948663nemeses
neumes83112623neum_es
newbies12147423newbies
newies91014073ne_wies
newsies101310383newsies
peavies122213403peavies
peeries93623023peeries
pennies94218813pennies
peonies93620153peonies
permits11314003permits
perries93226603perries
pigmies122610993pigmies
pommie123710503pommie_
preemies12512193preemies
premies113823063premies
pygmies15205673pygmies
ramies84630463_ramies
rammier112811023rammier
rammiest12299933rammiest
readies83324713readies
redries83721713redries
reemits9611303reemits
reflies104418533reflies
refries104419733refries
regimes104514743regimes
reifies104218283reifies
relies65036423re_lies
remails94714563remails
remains94117913remains
remakes134116173remakes
remates93827113remates
remedies11310553remedies
remiges103015473remiges
remise84221953re_mise
remises93423483remises
remiss84216353re_miss
remits85622943re_mits
remixes164313873remixes
remotes94521613remotes
removes124514713removes
replies94521043replies
reties65436193re_ties
retimes95020173retimes
retries74129073retries
roomies93017243roomies
rummier11309563rummier
rummiest12299353rummiest
seamier93114633seamier
seamiest102715423seamiest
selkies113513353selkies
sememes11109203sememes
semes75731583se_m_es
semis74623533se_mi_s
semises93916553semises
series64540973se_ries
serries73925353serries
shammies15259693shammies
shimmies15287803shimmies
stemmier1245253stemmier
stemmiest1335143stemmiest
stimies9316563stimies
stymies1239213stymies
summits1137983summits
swamies123712063swamies
tammie104212693tammie_
techies12513603techies
teddies92711283teddies
tekkies1035943tekkies
tellies73820503tellies
temples112610893temples
tennies73017973tennies
termites10313693termites
terries73425633terries
veeries102916893veeries
veggies1237553veggies
vegies104314273ve_gies
vermes115019143verm_es
vermis114214963vermi_s
wearies103020223wearies
wedgies123910213wedgies
weenies102915093weenies
weepies122811743weepies
wellies103719073wellies
whammies18265513whammies
yummier14306843yummier
yummiest15256723yummiest
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.423422437.4
2DLD Change Limit1340273045.67023637.9
3Display Results3043040.1102763.6
 (SQL Overall)1786913046.20328807.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.