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

267 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
hagdons125852(None) 
hagdon1188281hagdon_
agons66423782_ag_ons
cardons104519932cardons
hadrons113314302hadrons
halons95720712ha_lons
hangdogs1443602hangdogs
hardens113815022hardens
lagoons839252lagoons
lardons83914492lardons
pardons103817622pardons
radons74118532ra_dons
waggons1235502waggons
wagons103911212wag_ons
abandons1145353abandons
adonis7314063_a_donis
adorns74212613_a_dorns
ados57633513_a_do_s
aeons57624653_a_eons
agios65919863_agio_s
agon56531883_ag_on_
agone65924553_ag_one
agones75719863_ag_ones
agony96415653_ag_ony
aldols7109713_aldols
anions64123033_anions
anyons94513503_anyons
aprons8316993_aprons
ardors74416873_ardors
argons75018203_argons
arsons63917213_arsons
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
baboons113211083baboons
bacons104917583ba_cons
ballons93916963ballons
bandogs1138363bandogs
barons85025383ba_rons
baryons121010473baryons
basions94213953basions
batons85519423ba_tons
baudrons1135763baudrons
caldrons1138063caldrons
camions113916133camions
candors104216763candors
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capons104119503ca_pons
carbons115418943carbons
cardon94120853cardon_
cardoons113411943cardoons
cartons94122473cartons
cations94524143cations
chadors1338753cha_dors
chagrins1437073chagrins
chaldrons1545493chaldrons
chansons1337473chansons
chignons1444713chignons
codons96119463_codons
cogons96818113cog_ons
cordons104415763cordons
dacrons103211033dacrons
dadoes85616533da_does
dados75522433da_do_s
daemons10269233daemons
dagoes85714603dag_oes
dagos76419443dag_o_s
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damsons1038013damsons
dogdoms1295423dogdoms
dons56048703___dons
dragons938383drag_ons
dragoons1045013dragoons
fados95620733fa_do_s
faggots1234863faggots
fagins10513863fag_ins
fagots1039963fag_ots
falcons1239123falcons
fandoms13229473fandoms
fanions103713073fanions
fanons96115213fa_nons
flagons1137973flag_ons
fogdogs1333263fogdogs
gabions102410053gabions
gaboons10289903gaboons
gallons83015953gallons
gammons1237973gammons
garcons102411643garcons
gardens93312093gardens
garrons82713463garrons
gascons10289103gascons
goons65326773__goons
guidons936623guidons
haboobs1495463haboobs
haddock1885583haddock
haddocks1984903haddocks
hades96035113ha_d_es
hading113922943ha_ding
hadjes175210403ha_djes
hadjis17439653ha_djis
hadron102913753hadron_
haemins122811403haemins
hagborn1344953hagborn
hagbuts1354933hagbuts
hagging133114683hagging
haggis11209513hag_gis
haggles123312483haggles
hagrode1236443hagrode
hags86740843hag___s
hairdos1136823hairdo_s
halcyons1644023halcyons
halidoms1485823halidoms
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallows134417393hallows
haloes94623863ha_loes
halon86124863ha_lon_
halos85230253ha_lo_s
hambone1439313hambone
hambones1539673hambones
handers114224333handers
handguns1344363handguns
handing123518893handing
handles114020653handles
handoff1756483handoff
handoffs1844733handoffs
handout11314103handout
handouts1238233handouts
hands95327383hand__s
hangdog1343133hangdo_g
hansoms12238523hansoms
haplont12412563haplont
haplonts1345773haplonts
happens14359173happens
haptens124511343haptens
harbors12412413harbors
hardass1139753hardass
harden105718533harden_
hardies114923233hardies
hardnose1245723hardnose
hardpans1436453hardpans
hards96435653hard__s
hardtops1444843hardtops
harkens144112863harkens
harlots103413293harlots
harmins123716723harmins
harmony1538173harmony
harpins123615703harpins
harpoons1337483harpoons
harrows132611033harrows
hastens106214813hastens
hatpins123410643hatpins
hausens1077633hausens
havens124514043ha_vens
haviors1347383haviors
havocs1435653ha_vocs
haymows1883813haymows
hazans183411653ha_zans
hazzans18215783hazzans
hegemons1444893hegemons
herons94820543h_erons
hexagons1943943hexag_ons
hoddens12378803hoddens
hoddins12289373hoddins
hoedowns15124653hoedowns
hogans105914313hog_ans
hoidens11329083hoidens
hons77350783h___ons
hoodoos11109293hoodoos
hotdogs1234453hotdogs
hoydens14347403hoydens
hugeous1137133hugeous
hysons1237633h_ysons
jargons1558203jargons
jargoons1644663jargoons
kaons95014853ka__ons
kations114013663kations
ladens74516233la_dens
ladrons83813193ladrons
lagans75717783lag_ans
lagoon7410483lagoon_
lapdogs1134073lapdogs
lardon74415063lardon_
lardoons9398483lardoons
legions84611783legions
logions86211293logions
logons79818173log_ons
macons104017243ma_cons
macrons113514893macrons
maddens11359753maddens
maggots1136563maggots
magians10310753magians
magots9312363mag_ots
maidens10349663maidens
mammons1048513mammons
maroons92615553maroons
marrons93216973marrons
mascons113411583mascons
masons83916513ma_sons
matrons93517633matrons
mignons1037863mignons
nandins8312003nandins
nasions73112383nasions
nations74720563nations
natrons73215663natrons
paeons83915523pa_eons
pagans95717923pag_ans
pagodas11367553pagodas
pagods105310193pag_ods
pardon94618733pardon_
parsons93516873parsons
partons94620513partons
patrons93818103patrons
phaetons1345853phaetons
pigeons1039183pigeons
racons84319343ra_cons
racoons93912433racoons
radon64620503ra_don_
raglans82410133raglans
ragtops1035453ragtops
ramsons939563ramsons
randans8313213randans
randoms102112433randoms
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
rayons94113343ra_yons
redons75222183_redons
regions83613473regions
rhabdoms1643343rhabdoms
saddens9309603saddens
sagos66123873sag_o_s
salmons93713263salmons
salons63823693sa_lons
saloons74415323saloons
shadows1437193sha_dows
shahdoms1743773shahdoms
talions7314113talions
talons64019443ta_lons
tampons112711563tampons
tardyons1244613tardyons
tarpons92612213tarpons
tauons63412673ta_uons
taxons134211503ta_xons
tendons8311473tendons
tiglons837343tiglons
tigons74112263tig_ons
udons65411463__udons
voudons1135323voudons
waggon1136393waggon_
wagon94312953wag_on_
wanions104011373wanions
wantons103713013wantons
wardens113711903wardens
wigeons1136983wigeons
yapons114411773ya_pons
yaupons12345683yaupons

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.410435831.7
2DLD Change Limit1340272675.79623124.1
3Display Results2672670.0932871.0
 (SQL Overall)1786912676.29928368.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.