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

428 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
hoagie10231001(None) 
hoagies112811991hoagies
bogie89524102bo_gie
boogie93515992boogie
bougie93613272bougie
doggie93910892doggie
dogie75222792do_gie
fogie96719002fo_gie
goalie7413162goalie
hoagy124710472hoag_y
hoarier104211742hoarier
hoarse94411322hoarse
hogtie102711772hogtie
homage121210602homag_e
homie104622532ho_mie
hongi96715872hongi_
hongied12308162hongied
hongies112716472hongies
honkie133011672honkie
hoodie105116142hoodie
hoolie93217782hoolie
hottie92514382hottie
howdie13349732howdie
loggie84011992loggie
moggie103210102moggie
noogie73612312noogie
roadie72813812roadie
vogie95116662vo_gie
adage7414053adag_e
adagio847673adagio
age47154333__ag_e
agee56241493__agee
aggie73415013_aggie
agile65122263__agile
agin56132713__agin
agio57828453__agio
ague55725923__ague
amie66339853__amie
baggie102912193baggie
beagle93612593beagle
beanie83618593beanie
biggie103810933biggie
boccie123311453boccie
boggier113711583boggier
boggle104511943boggle
bogies94724313bo_gies
bogle85821683bo_gle
bonnie85314853bonnie
boobie104015293boobie
boogied11379283boogied
boogies103719013boogies
bookie123516003bookie
bootie85421163bootie
borage93917013borag_e
bougies103715183bougies
budgie104310343budgie
cage75339063_cag_e
cagier93715933_cagier
cavie104621593_cavie
cheapie1437563cheapie
choanae1236863choanae
choragi1346683choragi_
choragic1646063choragic
coalier93416183coalier
coarse84813903coarse
coatee84327223coatee
coati75624643coati_
coatis85122603coatis
coigne94612193coigne
collie83621993collie
commie124215523commie
conge85227593cong_e
congee96024473congee
congii957363congii
cookie123716043cookie
coolie83821603coolie
cootie84223093cootie
corbie103618203corbie
corgi8316083corgi_
corgis9314413corgis
corrie83621223corrie
cosie74728263co_sie
cowage12310673cowag_e
cowpie133511513cowpie
cowrie113814283cowrie
cozie163519133co_zie
dearie73319813dearie
dhootie1136473dhootie
doable93115243doable
dobie84920333do_bie
dodge86618133dodg_e
dodgier10388243dodgier
doge66233803do_g_e
doggier103810943doggier
doggies103613023doggies
dogies85022253do_gies
dongle83612493dongle
donsie7613643donsie
doobie94712683doobie
doolie73916833doolie
doozie163910653doozie
dormie9312623dormie
dosage82810003dosag_e
dotage82711613dotag_e
dowie94721143do_wie
doxie136017153do_xie
dragee84415603dragee
eagle64219483_eagle
eagre64315323_eagre
fagin9216573_fagin
foamier12339003foamier
foggier12349913foggier
fogies104118063fo_gies
folkie13369613folkie
foodie104413843foodie
footie94718143footie
forage104617003forag_e
forge95126943forg_e
forgive1436193forgive
fragile1147843fragile
gage65936103_gag_e
ghoulie1144263ghoulie
gie47149543___gie
goalies8316023goalies
goatee73219533goatee
goggle94511573goggle
goodie83613993goodie
goonie73615563goonie
gorge76423893gorg_e
gouge78220063goug_e
habile11515213h_abile
habit103027023h_abit
hackie154615623hackie
hade85440193h_a_de
hae67364003h_a__e
hafiz20611213h_afiz
hag77255743h_ag__
hagged124317703h_agged
haggis11209513haggis
haggle113511983haggle
hagride1237553h_agride
hags86740843h_ag_s
haik115526983h_a_ik
hail74839063h_a_il
hair76330143h_a_ir
haji148520193h_aji_
hajis156716283h_ajis
hake115637843h_a_ke
hakim14311833h_akim
hale76052833h_a_le
halid94424983h_alid
halide103417993h_alide
halite93624233h_alite
halve114818923h_alve
hame97043133h_a_me
hance105424153h_ance
hankie133915713hankie
hanse85722793h_anse
haole84820083h_aole
hare76255733h_a_re
haste85927863h_aste
hate78450173h_a_te
haute89521613h_aute
have106137073h_a_ve
hawkie163810093hawkie
hawse116015123h_awse
haze164833393h_a_ze
hazier184712403h_azier
headier113212953headier
hearse94114273hearse
heaume1137543heaume
heave114521813hea_ve
heavier13429423heavier
heavies132713873heavies
hedge105317353hedg_e
hedgier12367883hedgier
heinie92512663heinie
hempie132410563hempie
henge94819833heng_e
hickie153812473hickie
hie67652703h___ie
higgle113811743higgle
hinge95323453hing_e
hippie132811243hippie
hoar76729163hoa__r
hoard94918313hoa_rd
hoarded12368343hoarded
hoarder11329233hoarder
hoards104912623hoards
hoariest11312883hoariest
hoarily1338973hoarily
hoars85925553hoa_rs
hoarsen10367993hoarsen
hoarser10388393hoarser
hoary114516763hoa_ry
hoatzin1943943hoatzin
hoax147718293hoa__x
hoaxed17378873hoaxed
hoaxer16348563hoaxer
hoaxes163611693hoaxes
hoaxing18307763hoaxing
hobbies143813343hobbies
hobbit132810543hobbit
hobble133913433hobble
hoblike16158303hoblike
hoddin11369943hoddin
hoe67562723ho___e
hoelike141411163hoelike
hog78049063ho_g__
hogan97817703ho_gan
hogans105914313hogans
hogg96617533ho_g_g
hogged125817773hogged
hogger114615083hogger
hogget114715763hogget
hogging133112803hogging
hoggish15247593hoggish
hoggs107212463ho_ggs
hoglike15157733hoglike
hogs87139663ho_g_s
hogtied12226653hogtied
hogties112813993hogties
hoise85224773ho_ise
hoke115935933ho__ke
hokier134214033ho_kier
hole77553393ho__le
holier94921623ho_lier
holies94630033ho_lies
hollies103420813hollies
holmic1338783holmic
homaged1497413homaged
homager13107853homager
homages131011583homages
homaging1536613homaging
hombre13309303hombre
home98042443ho__me
homier116416993ho_mier
homies114524723ho_mies
hondle103914523hondle
hone77549323ho__ne
hong85833953hong__
hongs95126203hong_s
honied104818393ho_nied
honkies143015143honkies
hoochie1537803hoochie
hoodier113812973hoodier
hoodies113419833hoodies
hookier143811673hookier
hookies144017443hookies
hoopoe11911233hoopoe
hootier104915353hootier
hope96639673ho__pe
hoplite12311073hoplite
hoppier143110703hoppier
hopple132910483hopple
horde94623053ho_rde
hornier103012463hornier
horrid10311563horrid
horse86132653ho_rse
horsier103013243horsier
horste94817413horste
hose76547243ho__se
hosier94219613ho_sier
hospice14117063hospice
hostage113111233hostag_e
hostile10312553hostile
hotline10712353hotline
hotties103016963hotties
houri85915253houri_
houris94514583houris
house89131423ho_use
hove107132223ho__ve
howdied15296843howdied
howdies142911953howdies
howe106734103ho__we
hoyle11314413ho_yle
huge86321653h_ug_e
hunkie133812383hunkie
hyalin122210043hyalin
hyaline132310723hyaline
hyalite13229473hyalite
image81411293imag_e
imagine1037883imagine
joggle154010353joggle
kookie9389843kookie
koppie14277883koppie
league758743league
loamier9349163loamier
loathe94211383loathe
lodge76520093lodg_e
loge56837193lo_g_e
loggia8457053loggia
loggier93811143loggier
logia68116603lo_gia
logic88217833lo_gic
logier75015733lo_gier
login66025003lo_gin
longe66626463long_e
longies82916553longies
looie55624243lo_oie
loonie64216453loonie
louie55023513lo_uie
lovage1037353lovag_e
luggie8318903luggie
mage75739133_mag_e
magi76329533_magi_
magic105818653_magic
magpie1139093_magpie
mamie95826003_mamie
mavie104722563_mavie
meagre9349323meagre
mealie82519813mealie
meanie83718393meanie
moggies113111723moggies
mollie83517103mollie
mongoe94214983mongoe
monie75631653mo_nie
morgue938113morgue
movie105319133mo_vie
moxie144018123mo_xie
noggin8288883noggin
nonage7313683nonag_e
noogies82814583noogies
nookie103712433nookie
oakier104011393_oakier
oasis56422553_oasis
ogee57629883_o_gee
ogive9379093_o_give
ogle56325053_o_gle
ogre56320743_o_gre
ohmage1295063ohmag_e
oldie6415473_oldie
oorie53026363_oorie
orgic8311823_orgic
orgies72316093_orgies
ourie54027303_ourie
page76036103_pag_e
peage84723573peag_e
phage115113673phag_e
piggie103210773piggie
plage84520403plag_e
plague93610853plague
podgier11338723podgier
pogies94123543po_gies
pommie123710503pommie
pongee94920193pongee
pongid104111583pongid
popsie103013053popsie
porgies103017003porgies
postie84123963postie
potage92715903potag_e
potpie103412433potpie
potsie83916033potsie
rage55742353_rag_e
ragee65432663_ragee
ragi56032283_ragi_
ragis66325603_ragis
ramie75027823_ramie
reagin74915533reagin
roadies83317443roadies
rogue66417533ro_gue
roofie93411173roofie
rookie103613263rookie
roomie83013873roomie
rouge65423443roug_e
sage55044593_sag_e
sagier73717163_sagier
shavie124312423shavie
shoalier1137073shoalier
shogi95014013sho_gi_
shogis103810943sho_gis
shortie10411343shortie
soapier93411713soapier
soave84219053soa_ve
socage91012123socag_e
softie93312483softie
soggier93410883soggier
soigne74310033soigne
sonsie6614863sonsie
sortie63621993sortie
spavie113611383spavie
stage65330193stag_e
staggie9138463staggie
stagier83513443stagier
stogie7311323stogie
swage94919563swag_e
swaggie12135783swaggie
tawie84819813_tawie
toadied9248013toadied
toadies82914863toadies
togae67020113to_gae
togate74515683togate
toggle83810873toggle
togue64816303to_gue
tongue7410093tongue
toonie63617993toonie
toughie1187593toughie
towage1039833towag_e
towie85821873to_wie
townie93312303townie
tragi64717173tragi_
tragic93811543tragic
unagile838283unagile
usage6410213usag_e
vagi86719363_vagi_
vagile10310543_vagile
vague96513113_vague
veggie1136303veggie
vegie94614513_vegie
vogue95613043vo_gue
voyage1335473voyag_e
wage84834083_wag_e
wedgie11428373wedgie
whoopie15295933whoopie
wodge107212933wodg_e
woodie103513613woodie
woolie93514483woolie
yagi86922243_yagi_
yagis95416573_yagis
yogee9518063yo_gee
yogi86120423yo_gi_
yogic116114933yo_gic
yogin98317743yo_gin
yogis95617743yo_gis
yowie114616453yo_wie
zoaria1548383zoaria
zombie1937323zombie
zowie174313843zo_wie

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 Limit1127164284.89023050.3
3Display Results4284280.1403057.1
 (SQL Overall)1786914285.40633054.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.