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

379 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
jammier1840802(None) 
gammier123711191gammier
hammier143510651hammier
jammer174014131jamm_er
jammies183611291jammies
rammier112811021rammier
balmier113811512balmier
barmier114313042barmier
cammie124615292cammie_
cammies134016482cammies
campier133313272campier
clammier1435842clammier
dammer114317932damm_er
gambier124711972gambier
gamier93617932ga_mier
gammer1112318332gamm_er
gemmier12337382gemmier
gummier12349472gummier
hammer138120032hamm_er
jaggier16339182jaggier
jammed183811502jamm_ed
jammers183710702jamm_ers
jammiest19307202jammiest
jamming19329792jamming
jazzier2233882jazzier
jemmied19294482jemmied
jemmies18318332jemmies
jimmie17376472jimmie_
jimmied19275032jimmied
jimmies18328782jimmies
jumpier18317942jumpier
lambier113611642lambier
malmier113611952malmier
mammer94218862mamm_er
mammie94313782mammie_
mammies104314762mammies
palmier113312172palmier
rammer103519652ramm_er
rummier11309562rummier
tammie104212692tammie_
tammies113814682tammies
vampier14308232vampier
yammer133713182yamm_er
yummier14306842yummier
achier113914263_achier
admire949933_admire
admirer1035523_admirer
aerier64823153_aerier
aimer75926823_aim_er
airier64619363_airier
almner85710723_almner
ambeer104511603_ambeer
amber94523213_a_mber
ambler104916453_ambler
ameer75618983_a_meer
amie66339853_a_mie_
amies76837693_a_mies
amir65129753_a_mi_r
ammeter1148393_ammeter
ammine10314493_ammine
ammines11312673_ammines
ammino1069883_ammino
ampler104313303_ampler
amuser84712623_amuser
armer76924443_arm_er
armies85123693_armies
armiger1036253_armiger
artier63419733_artier
ashier94714833_ashier
babier103515573ba_bier
baggier113611643baggier
balkier134111983balkier
bammed133913243bamm_ed
bamming144611813bamming
barkier133814483barkier
barmie103816393barmie_
barnier93213673barnier
barrier94017733barrier
battier93515713battier
bawdier13378203bawdier
beamier113411943beamier
boomier113312183boomier
bummer124014103bumm_er
bumpier13359203bumpier
cagier93715933ca_gier
cahier113615773ca_hier
cakier123115243ca_kier
calmer105216933calm_er
camber124418483ca_mber
camper124722213ca_mper
cannier94014163cannier
carrier93619583carrier
cashier123713323cashier
cattier93317073cattier
chammied18215973chammied
chammies172910163chammies
chummier1734513chummier
clammer134211793clamm_er
comfier1439163comfier
commie124215523commie_
commies133718453commies
crammer134010963cramm_er
crampier14288903crampier
crummier1435603crummier
cummer124414593cumm_er
daffier1457833daffier
dallier84215373dallier
damager1157973damager
dammar11438903damm_ar
dammed124214793damm_ed
dammers123214273damm_ers
damming133812743damming
dammit11311133dammi_t
damner95213433da_mner
damper114117753da_mper
dandier93714573dandier
dashier114311183dashier
daubier1037103daubier
dimmer114112613dimm_er
doomier103610123doomier
dummied13346723dummied
dummies123012133dummies
dumpier12409653dumpier
earlier72612743earlier
easier64218463ea_sier
elmier839813_elmier
emmer94314463_emm_er
faddier1237783faddier
faggier12309843faggier
fancier123412063fancier
farmer115017373farm_er
farrier103514893farrier
fattier103513463fattier
fawnier13296363fawnier
filmier1237503filmier
flamier123112143flamier
foamier12339003foamier
fumier11310903_fumier
gabbier12379633gabbier
gambiers13337073gambiers
gambir11509773gambi_r
gambler123612683gambler
gamer84928943ga_m_er
gammed124216163gamm_ed
gammers123214563gamm_ers
gammiest13339323gammiest
gamming133112623gamming
gammoner1345153gammoner
gappier12369843gappier
gassier83812573gassier
gaudier938453gaudier
gauzier1735633gauzier
gawkier15326523gawkier
germier10309543germier
gimmie11298183gimmie_
gimmies123010113gimmies
gimpier12247943gimpier
grimier103210433grimier
gummer114615453gumm_er
hairier103111053hairier
hammed144116973hamm_ed
hammerer15278143hammerer
hammers144216063hamm_ers
hammiest152610003hammiest
hammily1736063hammily
hamming153014093hamming
hamper134518653ha_mper
hamster12810423hamster
handier113817443handier
happier143312033happier
hardier114721543hardier
harmer114719553harm_er
harrier104417753harrier
hastier103916623hastier
haulier1059943haulier
haulmier1333143haulmier
hazier184712403ha_zier
hemmer134112643hemm_er
hempier14319003hempier
homier116416993_homier
hummer133615273humm_er
humpier143110723humpier
immies102412443_immies
jabber173713643ja_bber
jacker194417583ja_cker
jackies202912623jackies
jaeger14397193ja_eger
jager134318133ja__ger
jagger154016003ja_gger
jaggies163311083jaggies
jailer134316683ja_iler
jambe165314753ja_mbe_
jambed184811403ja_mbed
jambes175914053ja_mbes
jambing19328533jambing
jamlike20126923jamlike
jammy194810193jamm__y
jangler153811833jangler
janglier1656113janglier
japer146218883ja__per
jasmin1538073jasmi_n
jasmine1636643jasmine
jasmines1736623jasmines
jasmins1637083jasmins
jasper154610383ja_sper
jauntier1535233jauntier
jazzer21376503ja_zzer
jerkier18407273jerkier
jettier14358693jettier
jiggier16377823jiggier
jimminy2133373jimminy
jimper17389863j_imper
jivier16438613j_ivier
jokier17618753j_okier
jollier142911003jollier
joltier14318493joltier
jowlier17327563jowlier
juicier1635463juicier
jumbler183910273jumbler
jumper173612373j_umper
junkier18339493junkier
lacier84020093la_cier
lakier104716273la_kier
lamber104418493la_mber
lambie103213673lambie_
lambies113015113lambies
lamer75233703la_m_er
lammed113915623lamm_ed
lamming123014583lamming
lamster9109913lamster
lankier113711633lankier
lardier83518343lardier
larkier113711523larkier
lathier10310833lathier
lazier154214613la_zier
limbier11349113limbier
limier83518723_limier
limmer104314793limm_er
loamier9349163loamier
lumpier113410143lumpier
maimer104514593maim_er
maltier93015483maltier
mamie95826003ma_mie_
mamies104626243ma_mies
mammae94613213mammae_
mammee94417853mamm_ee
mammees104411143mammees
mammers104615693mamm_ers
mammet94319253mamm_et
mammey124310893mamm_ey
mamzer19459833ma_mzer
mangier104114063mangier
manlier92414023manlier
marlier92614773marlier
marrier93817523marrier
massier93615223massier
matier84321523ma_tier
mazier175013063ma_zier
mimer94825763__mimer
mommies103912273mommies
mummer93614543mumm_er
mummied11327103mummied
mummies103812843mummies
naggier9309153naggier
namer75622103na_m_er
nappier114411173nappier
nastier74115293nastier
nattier73614623nattier
oakier104011393oa_kier
pacier105018683pa_cier
palier85023563pa_lier
pallier94417163pallier
palmer105816543palm_er
pamper124316663pa_mper
panier84425503pa_nier
pannier93613353pannier
pappier103511593pappier
parrier93717653parrier
partier93520713partier
pastier94320383pastier
pawkier16236613pawkier
plumier113510043plumier
plummier1434123plummier
pommie123710503pommie_
pommies133712843pommies
premier113515633premier
qualmier1934563qualmier
racier85120973ra_cier
rainier71614263rainier
rallier73816273rallier
rambler113313263rambler
ramie75027823ra_mie_
ramies84630463ra_mies
rammed113117303ramm_ed
rammers113715043ramm_ers
rammiest12299933rammiest
ramming123115063ramming
rammish1437563rammish
randier83618473randier
rangier83714353rangier
rapier84019993ra_pier
raspier93110643raspier
rattier74015593rattier
rimier83916273_rimier
rimmer103516033rimm_er
roomier93812243roomier
rummer104715483rumm_er
rummies113212793rummies
saggier92912063saggier
sagier73717163sa_gier
sallier73320423sallier
saltier74318633saltier
samiel8313333sa_miel
sampler113212013sampler
sandier84017843sandier
sappier113613113sappier
sarkier113413313sarkier
sassier73413233sassier
saucier9810283saucier
savvier1335483savvier
scammer133611973scamm_er
scummier1445083scummier
seamier93114633seamier
shammer144613143shamm_er
shammied16265543shammied
shammies15259683shammies
simmer104115353simm_er
slammer113913033slamm_er
slimier93212013slimier
slummier1235473slummier
smarmier1235033smarmier
spammer133410433spamm_er
spumier1137903spumier
stammer116013343stamm_er
stemmier1245253stemmier
summer104017713summ_er
swampier1544593swampier
swimmier15174313swimmier
tackier133712523tackier
talkier114011843talkier
tallier72817213tallier
tamer75230103ta_m_er
tamper104618513ta_mper
tangier83013903tangier
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tartier74123263tartier
tastier711817093tastier
tattier74216243tattier
tawnier10318463tawnier
thymier1534393thymier
tommies113812983tommies
trampier12318243trampier
tummies113012033tummies
tummler11266613tummler
vamper134212653va_mper
vampire14296673vampire
varier94619353va_rier
vastier103613203vastier
wackier16369733wackier
wamblier15275733wamblier
wanier93920683wa_nier
warier93722893wa_rier
warmer113816733warm_er
wartier103413913wartier
washier133611153washier
waspier12259053waspier
wavier124613083wa_vier
waxier16439903wa_xier
whammies18265513whammies
wimpier14248053wimpier
wombier1436543wombier
wormier12278763wormier
yammerer15225483yammerer
yammers143410323yamm_ers
yummies14359533yummies
zanier154314713za_nier
zappier20458373zappier

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 Limit1340273796.03322215.6
3Display Results3793790.1402707.1
 (SQL Overall)1786913796.59327103.1
 
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.