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

302 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
dahoon103905(None) 
dahoons1137751dahoons
aboon74918702_aboon
baboon103613912baboon
cahoot11416472cahoot
dacron94310692dacron
daemon9279592daemon
daikon11217242daikon
daimon9259712daimon
dalton7311272dalton
damson938062damson
dehorn10439652dehorn
dragoon935282dragoon
gaboon93211772gaboon
lagoon7410482lagoon
maroon83118202maroon
racoon83814472racoon
ratoon64417372ratoon
saloon64418022saloon
shoon84022012_shoon
wahoo112413082wahoo_
wahoos122310592wahoos
yahoo112911542yahoo_
yahoos12209242yahoos
achoo10315083achoo_
acorn75616623_acorn
adjoin14107293adjoin
adnoun757033adnoun
adorn64917093_adorn
adown95611663_adown
aeon45634613_a_eon
afoot8420113_afoot
agon56531883_a_gon
ahold94714253_ahold
ahoy101919183_ah_oy
aloin55227423_aloin
aloof83521573_aloof
ancon75718233_ancon
anion55028813_anion
anon46134853_a_non
anyon85615223_anyon
apron7318833_apron
argon65520593_argon
arson55118833_arson
aswoon947013aswoon
avion84218343_avion
axion1211316913_axion
axon115524303_a_xon
azlon144312873_azlon
azon135725053_a_zon
baboo94319503baboo_
babool103012153babool
baboons113211083baboons
baboos103517013baboos
bacon95620593ba_con
ballon84117493ballon
balloon93711433balloon
baron78131243ba_ron
baryon111211613baryon
basion84315853basion
bassoon937613bassoon
baton75822423ba_ton
bazoo163815673bazoo_
bazoos173212623bazoos
behoof1458683behoof
bhoot104322103_bhoot
boon67142173__boon
bradoon1037353bradoon
cahoots1238473cahoots
cahow135110943cah_ow
cahows14399123cahows
cajon144513903ca_jon
camion103917193camion
cannon84514443cannon
canon74725303ca_non
canton85722993canton
canyon114512033canyon
capon95221873ca_pon
carbon104919043carbon
cardon94120853cardon
cardoon104813813cardoon
carton84522663carton
cartoon94114463cartoon
cashoo11312253cashoo_
cashoos12310793cashoos
cation83925503cation
chon96627793_ch_on
chook146015043_chook
cocoon10312263cocoon
coon67248943__coon
croon75522783_croon
dacoit9415453dacoit
dacrons103211033dacrons
dado67126333da_do_
dadoed9449903dadoed
dadoes85616533dadoes
dadoing1038523dadoing
dados75522433da_dos
daemons10269233daemons
dago65725093da_go_
dagoba1074943dagoba
dagoes85714603dagoes
dagos76419443da_gos
dagwood1344833dagwood
dah78148983dah___
dahl87019223dah__l
dahlia1035773dahlia
dahls95012283dah_ls
dahs88231813dah__s
daikons12186693daikons
daimen92210573daimen
daimons10249323daimons
dakoit11310353dakoit
dalapon1044893dalapon
daltons8310403daltons
daman84821163da_man
damn75724323da__mn
dampen114310593dampen
damsons1038013damsons
dan46859673da___n
danio6319783danio_
danios7314603danios
dapsone1038463dapsone
darken114013443darken
darn56434623da__rn
dasheen1136393dasheen
dashpot1346123dashpot
dato56129943da_to_
datos65222783da_tos
datto65416423datto_
dattos74311903dattos
daven94916473da_ven
dawen95413723da_wen
dawn85624203da__wn
daybook1744373daybook
daylong1233973daylong
dayroom1345233dayroom
deacon9510423deacon
dehorns11428363dehorns
dehort104618103dehort
demon86520313d_emon
devon95113683d_evon
dewool1047403dewool
dhobi1136973d_hobi
dhole95215363d_hole
dhooly13457143d_hooly
dhoora1035653d_hoora
dhooti1035663d_hooti
dhoti9310123d_hoti
dhow116614003d_h_ow
dhows125911223d_hows
diatron839283diatron
disown1036953disown
diuron738573diuron
doblon938013doblon
dobson936593dobson
don46757653d___on
donjon1436463donjon
doom76430073d__oom
door56928513d__oor
down86427493d__own
dragon838843dragon
dragoons1045013dragoons
dromon939363dromon
drool65416103d_rool
droop85814823d_roop
drown95515823d_rown
durion7510963durion
ethion938813ethion
falcon11310293falcon
fanion94514323fanion
fanon84619013fa_non
fashion1337843fashion
gabion93211033gabion
gaboons10289903gaboons
gadroon938173gadroon
gallon73715813gallon
galloon82910643galloon
galoot72719163galoot
gammon1138903gammon
garcon92912483garcon
garron73113493garron
gascon9339723gascon
gazoo153112873gazoo_
gazoos163010223gazoos
goon57236173__goon
haboob1377883haboob
hadron102913753hadron
hagdon1188283hagdon
halon86124863ha_lon
harpoon1238313harpoon
hon67759383__h_on
hood85132333__hood
hoof106036583__hoof
hook116133283__hook
hoop96129983__hoop
hoot75752103__hoot
horn76735613__horn
jargon1448823jargon
jargoon1545193jargoon
kaon87521023ka__on
karoo92519583karoo_
karoos102415803karoos
kation104315683kation
kazoo183311533kazoo_
kazoos19259113kazoos
kroon94514483_kroon
ladhood1246473ladhood
ladron73413323ladron
lagoons839253lagoons
lampoon11267193lampoon
lardon74415063lardon
lardoon83410373lardoon
loon47344793__loon
macon94519953ma_con
macron103615673macron
madzoon1996063madzoon
mahjong2042273mahjong
mahoe10315573mah_oe
mahoes11313103mahoes
mahout11415813mahout
mahzor2035113mahzor
mammon939643mammon
manhood1338993manhood
maroons92615553maroons
marron83717543marron
mascon103612743mascon
mason74820183ma_son
matron83918313matron
matzoon1896473matzoon
moon67140813__moon
nasion63914083nasion
nation64322803nation
natron64116023natron
noon47134623__noon
paeon74819493pa_eon
pardon94618733pardon
parson83817903parson
parton84720993parton
patron84018043patron
patroon92811973patroon
phon95925383_ph_on
phono104917023_phono
phonon114012033_phonon
photon1111514833_photon
platoon938953platoon
poon67341263__poon
raccoon1176163raccoon
racon75422143ra_con
racoons93912433racoons
radon64620503ra_don
ramson8310463ramson
ration64226013ration
ratoons73815473ratoons
ratton64116123ratton
rattoon7359243rattoon
rayon83815703ra_yon
salmon84614183salmon
salon55228553sa_lon
saloons74415323saloons
saloop84212583saloop
saxhorn1744223saxhorn
school11410723school
shoo75929893_shoo_
shook124920163_shook
shool84523153_shool
shoos84226363_shoos
shoot84235913_shoot
shorn85722183_shorn
shown115216483_shown
simoon858063simoon
soon46240503__soon
spoon74719443_spoon
swoon85014783_swoon
taboo73418093taboo_
taboos83815433taboos
tachyon1544623tachyon
talion6317713talion
talon55824113ta_lon
tampon102911233tampon
tarpon82812803tarpon
tauon54816583ta_uon
taxon124414663ta_xon
thorn85318703_thorn
thoron94713903_thoron
toon47740633__toon
tycoon1136023tycoon
typhoon1544653typhoon
unhood1039233unhood
unhook1347523unhook
varoom11411413varoom
waggon1136393waggon
wagon94312953wa_gon
wanion93213063wanion
wanton94413813wanton
wazoo173011173wazoo_
wazoos18288553wazoos
whoof144612693_whoof
whoop134211443_whoop
yapon104613583ya_pon
yaupon11345493yaupon
zoon137326983__zoon

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 Filter1786911127160.406440125.6
2DLD Change Limit1127163026.00018786.0
3Display Results3023020.0933247.3
 (SQL Overall)1786913026.49927495.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.