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

275 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
jimmies1832878(None) 
gimmies123010111gimmies
immies102412441_immies
jammies183611291jammies
jemmies18318331jemmies
jimmie17376471jimmie_
jimmied19275031jimmied
cammies134016482cammies
commies133718452commies
dummies123012132dummies
gimmes113010902gimm_es
gimmie11298182gimmie_
immixes1835072_immixes
jammier18408022jammier
jammiest19307202jammiest
jemmied19294482jemmied
jiffies20327472jiffies
jimminy2133372jimminy
mammies104314762mammies
mommies103912272mommies
mummies103812842mummies
pigmies122610992pigmies
pommies133712842pommies
rummies113212792rummies
shimmies15287802shimmies
tammies113814682tammies
tommies113812982tommies
tummies113012032tummies
yummies14359532yummies
amies76837693__amies
amities9317383amities
ammines11312673_ammines
anomies93316993anomies
armies85123693_armies
atomies93918363atomies
bialies93618413bialies
biddies113514493biddies
biffies152710853biffies
bigamies1337373bigamies
biggies113813523biggies
bikies124515163bi_kies
bilbies114712343bilbies
billies93923503billies
bimboes13498733bimboes
biomes103815253biom_es
birdies104016213birdies
birkies133712433birkies
cammie124615293cammie_
chammies172910163chammies
cimices13279803cimices
cissies94116153cissies
cities84524853ci_ties
civies114116443ci_vies
civvies1555843civvies
commie124215523commie_
commits133812383commits
commixes2177353commixes
crummies1437643crummies
cummins1358963cummins
demies94825803_demies
diamides1238823diamides
diamines11311643diamines
diamins10312213diamins
diaries83321953diaries
dickies143416343dickies
didies84621833di_dies
digamies1238643digamies
dillies84122163dillies
dimes85833043di_m_es
dimities11314003dimities
dimmed124110323dimm_ed
dimmer114112613dimm_er
dimmers123811563dimmers
dimmest1249253dimm_est
dimming13339593dimming
dimples122813213dimples
dimwits1344513dimwits
dingies93618243dingies
dinkies123716033dinkies
dirties83119383dirties
dismes95617673dism_es
dismiss1038153dismiss
ditties83116983ditties
divvies1457663divvies
dizzies16279753dizzies
dummied13346723dummied
enemies9313693enemies
femmes135410213femm_es
fifties132111083fifties
fillies103420253fillies
filmier1237503filmier
filmiest1338553filmiest
filmis114610283filmi_s
fimbles143510663fimbles
flimsies1335783flimsies
gammier123711193gammier
gammiest13339333gammiest
gemmier12337383gemmier
gemmiest13227633gemmiest
giddies103713363giddies
gillies84120963gillies
gimmals12225823gimmals
gimme102411343gimm_e_
gimmick1843273gimmick
gimmicks1942473gimmicks
gimpier12247943gimpier
gimpiest1338483gimpiest
gipsies1039903gipsies
girlies83013703girlies
gremmies1355993gremmies
gummier12349473gummier
gummiest13269033gummiest
gummites1346173gummites
hammier143510653hammier
hammiest152610013hammiest
hickies163614743hickies
hinnies103615103hinnies
hippies142813753hippies
hissies103915823hissies
homies114524723_homies
images91411463_images
imbibes1334693_imbibes
imbues1037983_imbues
imides94515343_imides
imids86015143_i_mids
imines84918353_imines
immesh1334113_imm_esh
immix1635033_immi_x
immixed1933573_immixed
immunes1136083_immunes
immures1136713_immures
impis96213853_impi_s
implies11312123_implies
indies73822783_indies
ivies84215763_i_vies
jackies202912623jackies
jaggies163311083jaggies
jambes175914053j_ambes
jammed183811503jamm_ed
jammer174014133jamm_er
jammers183710703jammers
jamming19329793jamming
jasmines1736623jasmines
jasmins1637083jasmins
jellies143816533jellies
jennies143511623jennies
jerkies183411583jerkies
jerries143817513jerries
jetties143613123jetties
jibes145520323ji__bes
jiggier16377823jiggier
jiggiest17277693jiggiest
jiggles164111433jiggles
jiminy1836273ji_miny
jimjams1742073jimjams
jimmy19538503jimm__y
jimmying2342383jimmying
jimper17389863ji_mper
jimpest18297553ji_mpest
jingles153816383jingles
jingoes153811443jingoes
jinnis13489053jinni_s
jinxes20428233ji_nxes
jisms14458003jism__s
jives154820813ji__ves
jivier16438613ji_vier
jiviest1738113ji_viest
jollies143516273jollies
jumbles183013323jumbles
jumpier18317943jumpier
jumpiest1936863jumpiest
junkies183711693junkies
juries134120633j_uries
jutties143814003jutties
kiddies133412283kiddies
killies113318113killies
kilties113014143kilties
kitties113213623kitties
lambies113015113lambies
lilies63021413li_lies
limbier11349113limbier
limbiest12258893limbiest
limes75636503li_m_es
limier83518723li_mier
limiest93716103li_miest
limites92915453limites
limits82514143li_mits
limmer104314793limm_er
limmers113413083limmers
lindies8416583lindies
mamies104626243_mamies
mammees104411143mammees
mammie94313783mammie_
middies113116153middies
mimes95732023mi_m_es
mimeses1139073mimeses
mimics1289363mi_mics
minnies93617363minnies
mislies92922283mislies
missies93423983missies
mummied11327103mummied
nifties102612503nifties
nimmed11368573nimm_ed
nimming12358143nimming
ninnies73713613ninnies
nixies135313873ni_xies
pieties9419223pieties
piggies113813483piggies
pimples133012423pimples
pinkies133818263pinkies
pinnies93318443pinnies
pismires1235883pismires
pities83828083pi_ties
pixies154915513pi_xies
pommie123710503pommie_
premies113823063premies
pygmies15205673pygmies
ramies84630463_ramies
rammier112811023rammier
rammiest12299933rammiest
rimes75634543ri_m_es
rimfires1344203rimfires
rimier83916273ri_mier
rimiest93215853ri_miest
rimmed114812303rimm_ed
rimmer103516033rimm_er
rimmers113812883rimmers
rimming123411073rimming
rimples113114223rimples
roomies93017243roomies
rummier11309563rummier
rummiest12299353rummiest
shammies15259693shammies
shimmied16294983shimmied
sickies133717503sickies
silkies113715693silkies
sillies73425083sillies
similes92915233similes
simlins9311843simlins
simmer104115353simm_er
simmers113314613simmers
simonies10311113simonies
simples113014943simples
sissies73716603sissies
sixties14310973sixties
stimies9316563stimies
stymies1239213stymies
summits1137983summits
swamies123712063swamies
swimmier15174313swimmier
swimmiest1634253swimmiest
tammie104212693tammie_
tidies74721833ti_dies
timbres11249353timbres
times75630823ti_m_es
titties73617363titties
tizzies15287893tizzies
tsimmes1133673tsimm_es
tzimmes2033063tzimm_es
vichies15310623vichies
whammies18265513whammies
whimsies1635193whimsies
widdies123514033widdies
wienies102213683wienies
willies103920153willies
wimbles143010853wimbles
wimmin1336153wimmi_n
wimpier14248053wimpier
wimpiest1538763wimpiest
wimples143311173wimples
withies133913543withies
yippies14279293yippies
yummier14306843yummier
yummiest15256723yummiest
zombies2037993zombies

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.423422437.4
2DLD Change Limit1340272756.92319359.7
3Display Results2752750.0932957.0
 (SQL Overall)1786912757.43924020.8
 
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.