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

204 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
jimmie1737647(None) 
gimmie11298181gimmie
jimmied19275031jimmied
jimmies18328781jimmies
cammie124615292cammie
commie124215522commie
gimme102411342gimm_e
gimmies123010112gimmies
immies102412442_immies
immix1635032_immix
jammier18408022jammier
jammies183611292jammies
jemmied19294482jemmied
jemmies18318332jemmies
jimminy2133372jimminy
jimmy19538502jimm_y
mammie94313782mammie
pommie123710502pommie
tammie104212692tammie
wimmin1336152wimmin
amie66339853__amie
ammine10314493_ammine
anomie83215963anomie
barmie103816393barmie
biggie103810933biggie
bikie113915883bi_kie
billie85019173billie
biome94916993biom_e
birdie94013783birdie
birkie124110133birkie
cammies134016483cammies
civie103716353ci_vie
commies133718453commies
commit124016703commit
commix19407763commix
crummie1336153crummie
cummin1288783cummin
dammit11311133dammit
diamide1138473diamide
diamin9312523diamin
diamine10311983diamine
dickie133913113dickie
didie74120563di_die
dime76237643di_m_e
dimmed124110323dimmed
dimmer114112613dimmer
dimming13339593dimming
dimple113512793dimple
dimwit1237953dimwit
disme85716243dism_e
dormie9312623dormie
dummied13346723dummied
dummies123012133dummies
femme125011433femm_e
filmi105914003filmi_
filmic13348453filmic
filmier1237503filmier
filmis114610283filmis
fimble133611753fimble
gammier123711193gammier
gemmae11507793gemmae
gemmier12337383gemmier
gillie74816943gillie
gimmal11247513gimmal
gimmes113010903gimmes
gimmick1843273gimmick
gimpier12247943gimpier
girlie73711463girlie
gremmie1264383gremmie
gummier12349473gummier
gummite1236133gummite
hammier143510653hammier
hempie132410563hempie
hickie153812473hickie
hippie132811243hippie
homie104622533_homie
image81411293_image
imbibe1234703_imbibe
imbue939483_imbue
imid76122293_i_mid
imide85716893_imide
imine75821063_imine
immane1038883_immane
immixed1933573_immixed
immixes1835073_immixes
immune1035433_immune
immure1036033_immure
immy114611833_imm_y
impi85415793_impi_
impis96213853_impis
indie63721473_indie
jambe165314753j_ambe
jamlike20126923jamlike
jammed183811503jammed
jammer174014133jammer
jammiest19307203jammiest
jamming19329793jamming
jammy194810193jamm_y
jasmin1538073jasmin
jasmine1636643jasmine
jemmy19498553jemm_y
jibe136323393ji__be
jiffies20327473jiffies
jiggier16377823jiggier
jiggle153811993jiggle
jiglike19105333jiglike
jiminy1836273jiminy
jimmying2342383jimmying
jimp155618463ji_m_p
jimper17389863jimper
jimply20397483jimply
jimpy195210823ji_mpy
jingle143815223jingle
jinnee13411573jinnee
jinni125310633jinni_
jinnis13489053jinnis
jism135514773jism__
jisms14458003jism_s
jive146123593ji__ve
jivier16438613ji_vier
jumble174012653jumble
jumpier18317943jumpier
junkie17339603junkie
kiddie12359393kiddie
killie104114893killie
kiltie103210963kiltie
lambie103213673lambie
limbi96513813limbi_
limbic12528743limbic
limbier11349113limbier
lime66244933li_m_e
limier83518723li_mier
limit73126343li_mit
limmer104314793limmer
limnic10418843limnic
limpid11389753limpid
mamie95826003_mamie
mammae94613213mammae
mammee94417853mammee
mammies104314763mammies
mime85736403mi_m_e
mimic111414323mi_mic
mislie83219153mislie
mommies103912273mommies
mummied11327103mummied
mummies103812843mummies
nimbi94910313nimbi_
nimble103412943nimble
nimmed11368573nimmed
nimming12358143nimming
nixie125114943ni_xie
piggie103210773piggie
pigmies122610993pigmies
pimple123512963pimple
pinkie124414273pinkie
pismire1135353pismire
pixie145415523pi_xie
pommee122813283pommee
pommies133712843pommies
premie103617993premie
primsie1137543primsie
ramie75027823_ramie
rammier112811023rammier
rime65138883ri_m_e
rimfire1243793rimfire
rimier83916273ri_mier
rimmed114812303rimmed
rimmer103516033rimmer
rimming123411073rimming
rimose8310593rimose
rimple103814583rimple
roomie83013873roomie
rummier11309563rummier
rummies113212793rummies
shimmied16294983shimmied
shimmies15287803shimmies
sickie123715743sickie
silkie103313403silkie
simile83115633simile
simlin8311733simlin
simmer104115353simmer
simple104315173simple
stymie1137623stymie
summae103911013summae
summit10311543summit
swimmier15174313swimmier
tammies113814683tammies
timbre10328633timbre
time66235013ti_m_e
timid84815733ti_mid
titmice1144663titmice
tittie63213153tittie
tommies113812983tommies
tummies113012033tummies
widdie113410733widdie
wienie9229973wienie
willie94116453willie
wimble133211923wimble
wimpier14248053wimpier
wimple133611363wimple
yippie13277843yippie
yummier14306843yummier
yummies14359533yummies
zombie1937323zombie

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162044.64024292.2
3Display Results2042040.0633238.1
 (SQL Overall)1786912045.07935182.3
 
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.