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

485 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
hammier14351065(None) 
gammier123711191gammier
hammer138120031hamm_er
jammier18408021jammier
rammier112811021rammier
balmier113811512balmier
barmier114313042barmier
cammie124615292cammie_
cammies134016482cammies
campier133313272campier
chammied18215972chammied
chammies172910162chammies
chummier1734512chummier
clammier1435842clammier
dammer114317932damm_er
gambier124711972gambier
gamier93617932ga_mier
gammer1112318332gamm_er
gemmier12337382gemmier
gummier12349472gummier
hairier103111052hairier
hammed144116972hamm_ed
hammerer15278142hammerer
hammers144216062hamm_ers
hammiest152610012hammiest
hammily1736062hammily
hamming153014092hamming
hamper134518652ha_mper
hamster12810422hamster
handier113817442handier
happier143312042happier
hardier114721542hardier
harmer114719562harm_er
harrier104417762harrier
hastier103916622hastier
haulier1059942haulier
haulmier1333142haulmier
hazier184712402ha_zier
hemmer134112642hemm_er
hempier14319002hempier
homier116416992h_omier
hummer133615272humm_er
humpier143110722humpier
jammer174014132jamm_er
jammies183611292jammies
lambier113611642lambier
malmier113611952malmier
mammer94218862mamm_er
mammie94313782mammie_
mammies104314762mammies
palmier113312182palmier
rammer103519652ramm_er
rummier11309562rummier
shammer144613142shamm_er
shammied16265542shammied
shammies15259692shammies
tammie104212692tammie_
tammies113814682tammies
vampier14308232vampier
whammies18265512whammies
yammer133713182yamm_er
yummier14306842yummier
achier113914263_achier
admire949933_admire
admirer1035523_admirer
aerier64823163_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
armer76924453_arm_er
armies85123693_armies
armiger1036253_armiger
artier63419733_artier
ashier94714833_ashier
babier103515573ba_bier
baggier113611643baggier
balkier134111983balkier
bammed133913243bamm_ed
bamming144611813bamming
barkier133814483barkier
barmie103816403barmie_
barnier93213673barnier
barrier94017753barrier
battier93515723battier
bawdier13378203bawdier
beamier113411943beamier
boomier113312183boomier
bummer124014103bumm_er
bumpier13359203bumpier
cagier93715933ca_gier
cahier113615773ca_hier
cakier123115243ca_kier
calmer105216933calm_er
camber124418483ca_mber
camper124722213ca_mper
cannier94014163cannier
carrier93619583carrier
cashier123713323cashier
cattier93317073cattier
chaffier1935473chaffier
chalkier1736753chalkier
chamber164011063cha_mber
chamfer17399863cha_mfer
champer163813413cha_mper
chancier1538823chancier
charier124317903cha_rier
charmer144913663charm_er
charrier1378693charrier
chattier1337513chattier
chromier1538033chromier
clammer134211793clamm_er
comfier1439163comfier
commie124215523commie_
commies133718453commies
crammer134010963cramm_er
crampier14288903crampier
crummier1435603crummier
cummer124414593cumm_er
daffier1457833daffier
dallier84215383dallier
damager1157983damager
dammar11438913damm_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
farmer115017383farm_er
farrier103514893farrier
fattier103513463fattier
fawnier13296363fawnier
filmier1237503filmier
flamier123112143flamier
foamier12339003foamier
fumier11310903_fumier
gabbier12379633gabbier
gambiers13337073gambiers
gambir11509773gambi_r
gambler123612683gambler
gamer84928943ga_m_er
gammed124216163gamm_ed
gammers123214563gamm_ers
gammiest13339333gammiest
gamming133112623gamming
gammoner1345153gammoner
gappier12369843gappier
gassier83812573gassier
gaudier938453gaudier
gauzier1735633gauzier
gawkier15326523gawkier
germier10309543germier
gimmie11298183gimmie_
gimmies123010113gimmies
gimpier12247943gimpier
grimier103210433grimier
gummer114615453gumm_er
hacker154822693ha_cker
hackie154615623hackie_
hackies163418243hackies
hackler163512353hackler
hacklier1737133hacklier
haemic133210083haemi_c
haemin113412663haemi_n
haemins122811403haemins
hafter124815883ha_fter
haggler12328933haggler
hagrider1334483hagrider
hailer94720343ha_iler
haimish1537753haimish
hair76330143ha__i_r
haler85033533ha__ler
halter94420883ha_lter
hamate113319833hamate_
hamates122917683hamates
hame97043133ha_m_e_
hames106138703ha_m_es
hamlet113722793ha_mlet
hammada1545093hammada
hammal134512073hamm_al
hammals14409233hammals
hammam12419343hamm_am
hammams13386443hammams
hammered16218853hammered
hammerers16216563hammerers
hamminess1635713hamminess
hammock2064633hammock
hammy155113433hamm__y
hamperer15379093hamperer
hampers143616953ha_mpers
hamsters13710423hamsters
hamular1236983hamular
hanaper1237133hanaper
hander104526433ha_nder
handler113516163handler
hanger104023263ha_nger
hanker134622093ha_nker
hankie133915713hankie_
hankies143617763hankies
harder105022403ha_rder
hardies114923233hardies
harmed125218843harm_ed
harmers124116593harm_ers
harmin113117403harmi_n
harmine122816193harmine
harmines132715153harmines
harming133717933harming
harmins123716723harmins
harper115018403ha_rper
harpies123818323harpies
harried113815543harried
harriers113712433harriers
harries103525503harries
harsher13310363harsher
hatcher153314723hatcher
hater85034753ha__ter
hatmaker1785353hatmaker
hatter94724873ha_tter
hauler95015123ha_uler
hauliers1176713hauliers
haunter103111153haunter
haver115124463ha__ver
havior1248203ha_vior
hawker164812663ha_wker
hawkie163810093hawkie_
hawkies173311243hawkies
hawser125910843ha_wser
hayer114620243ha__yer
haymaker20104773haymaker
haywire1644743haywire
hazer174820233ha__zer
headier113212953headier
heartier1139103heartier
heathier1438343heathier
heavier13429423heavier
hedgier12367883hedgier
heftier1337203heftier
hemmed144211463hemm_ed
hemmers143310843hemm_ers
hemming15269973hemming
hempie132410563hempie_
herbier1239593herbier
hillier103413963hillier
hinkier143610793hinkier
hippier143212103hippier
hissier103410503hissier
hoarier104211743hoarier
hokier134214033h_okier
holier94921623h_olier
homager13107853homager
homelier1338983homelier
homer105828453h_om_er
homie104622533h_omie_
homies114524733h_omies
hoodier113812973hoodier
hookier143811673hookier
hootier104915353hootier
hoppier143110703hoppier
hornier103012463hornier
horsier103013243horsier
hosier94219613h_osier
huffier1637493huffier
hulkier14328973hulkier
humaner12257663humaner
humbler143411943humbler
hummed144812673humm_ed
hummers143813063humm_ers
humming153310673humming
humper134115883h_umper
hunkier144512143hunkier
hurrier103412943hurrier
huskier14369763huskier
immies102412443_immies
jaggier16339183jaggier
jammed183811503jamm_ed
jammers183710703jamm_ers
jammiest19307203jammiest
jamming19329793jamming
jazzier2233883jazzier
jemmied19294483jemmied
jemmies18318333jemmies
jimmie17376473jimmie_
jimmied19275033jimmied
jimmies18328783jimmies
jumpier18317943jumpier
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
mammae94613223mammae_
mammee94417853mamm_ee
mammees104411143mammees
mammers104615693mamm_ers
mammet94319253mamm_et
mammey124310893mamm_ey
mamzer19459833ma_mzer
mangier104114063mangier
manlier92414023manlier
marlier92614783marlier
marrier93817523marrier
massier93615223massier
matier84321523ma_tier
mazier175013063ma_zier
mimer94825763__mimer
mommies103912273mommies
mummer93614543mumm_er
mummied11327103mummied
mummies103812843mummies
naggier9309153naggier
namer75622103na_m_er
nappier114411173nappier
nastier74115293nastier
nattier73614623nattier
oakier104011393oa_kier
pacier105018683pa_cier
palier85023573pa_lier
pallier94417173pallier
palmer105816543palm_er
pamper124316663pa_mper
panier84425503pa_nier
pannier93613353pannier
pappier103511603pappier
parrier93717653parrier
partier93520713partier
pastier94320383pastier
pawkier16236613pawkier
plumier113510053plumier
plummier1434123plummier
pommie123710503pommie_
pommies133712843pommies
premier113515633premier
qualmier1934563qualmier
racier85120973ra_cier
rainier71614263rainier
rallier73816283rallier
rambler113313263rambler
ramie75027823ra_mie_
ramies84630463ra_mies
rammed113117303ramm_ed
rammers113715043ramm_ers
rammiest12299933rammiest
ramming123115063ramming
rammish1437563rammish
randier83618473randier
rangier83714353rangier
rapier84019993ra_pier
raspier93110643raspier
rattier74015593rattier
rehammer1544653rehamm_er
rheumier1342513rheumier
rimier83916273_rimier
rimmer103516033rimm_er
roomier93812243roomier
rummer104715483rumm_er
rummies113212793rummies
saggier92912063saggier
sagier73717163sa_gier
sallier73320433sallier
saltier74318633saltier
samiel8313333sa_miel
sampler113212013sampler
sandier84017843sandier
sappier113613123sappier
sarkier113413313sarkier
sassier73413233sassier
saucier9810283saucier
savvier1335483savvier
scammer133611973scamm_er
scummier1445083scummier
seamier93114633seamier
shabbier1535183shabbier
shadier113111153sha_dier
shaggier13116053shaggier
shakier143411153sha_kier
shalier103116423sha_lier
shammed153911423shamm_ed
shammers153710843shamm_ers
shammes144312833shamm_es
shamming16289413shamming
shimmer143310873shimm_er
shimmied16294983shimmied
shimmies15287803shimmies
simmer104115353simm_er
slammer113913033slamm_er
slimier93212013slimier
slummier1235473slummier
smarmier1235033smarmier
spammer133410433spamm_er
spumier1137903spumier
stammer116013343stamm_er
stemmier1245253stemmier
summer104017713summ_er
swampier1544593swampier
swimmier15174313swimmier
tackier133712523tackier
talkier114011843talkier
tallier72817223tallier
tamer75230103ta_m_er
tamper104618513ta_mper
tangier83013913tangier
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tartier74123263tartier
tastier711817093tastier
tattier74216243tattier
tawnier10318463tawnier
thrummier1641793thrummier
thymier1534393thymier
tommies113812983tommies
trampier12318243trampier
tummies113012033tummies
tummler11266613tummler
vamper134212653va_mper
vampire14296673vampire
varier94619353va_rier
vastier103613203vastier
wackier16369733wackier
wamblier15275733wamblier
wanier93920683wa_nier
warier93722893wa_rier
warmer113816743warm_er
wartier103413913wartier
washier133611153washier
waspier12259053waspier
wavier124613083wa_vier
waxier16439903wa_xier
whackier2044673whackier
whammed18345133whamm_ed
whamming19275223whamming
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 Limit1340274856.14321817.8
3Display Results4854850.1862607.5
 (SQL Overall)1786914856.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.