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

274 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
dahoons113775(None) 
dahoon1039051dahoon_
baboons113211082baboons
cahoots1238472cahoots
dacrons103211032dacrons
daemons10269232daemons
daikons12186692daikons
daimons10249322daimons
daltons8310402daltons
damsons1038012damsons
dehorns11428362dehorns
dragoons1045012dragoons
gaboons10289902gaboons
lagoons839252lagoons
maroons92615552maroons
racoons93912432racoons
ratoons73815472ratoons
saloons74415322saloons
wahoos122310592wahoo_s
yahoos12209242yahoo_s
aboon74918703_aboon_
acorns85013013_acorns
adjoins1585983adjoins
adnouns835453adnouns
adorns74212613_adorns
aeons57624653_a_eons
agons66423783_a_gons
aholds10469483_aholds
aloins65022203_aloins
anions64123033_anions
anyons94513503_anyons
aprons8316993_aprons
argons75018203_argons
arsons63917213_arsons
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
babools11319453babools
baboon103613913baboon_
baboos103517013baboo_s
bacons104917583ba_cons
ballons93916963ballons
balloons103110523balloons
barons85025383ba_rons
baryons121010473baryons
basions94213953basions
bassoons1036553bassoons
batons85519423ba_tons
bazooms20285383bazooms
bazoos173212623bazoo_s
bhoots11459913_bhoots
boons75031913__boons
bradoons1136763bradoons
cahoot11416473cahoo_t
cahows14399123cah_ows
camions113916133camions
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capons104119503ca_pons
carbons115418943carbons
cardons104519933cardons
cardoons113411943cardoons
cartons94122473cartons
cartoons104012803cartoons
cashoos12310793cashoo_s
cations94524143cations
chooks155312793_chooks
cocoons11310563cocoons
coons76737283__coons
croons85418423_croons
dacoits1079073dacoits
dacron94310693dacron_
dadoes85616533da_does
dadoing1038523dadoing
dados75522433da_do_s
daemon9279593daemon_
daemones11209163daemones
dagobas1145143dagobas
dagoes85714603da_goes
dagos76419443da_go_s
dagwoods1444583dagwoods
dahlias1135723dahlias
dahls95012283dah__ls
dahs88231813dah___s
daikon11217243daikon_
daimon9259713daimon_
daimones11208803daimones
dakoits1245293dakoits
dalapons1145443dalapons
dalton7311273dalton_
damans94715983da_mans
damns84916923da__mns
dampens12348563dampens
damson938063damson_
danios7314603danio_s
dans56748153da___ns
dapsone1038463dapsone
dapsones1138383dapsones
darkens12409873darkens
darns66927893da__rns
dasheens1244693dasheens
dashpots1444193dashpots
datos65222783da_to_s
dattos74311903datto_s
davens104612913da_vens
dawns95916593da__wns
daybooks1843983daybooks
daylong1233973daylong
dayrooms1444343dayrooms
deacons10310393deacons
dehorn10439653dehorn_
dehorts11379773dehorts
demons94917723d_emons
devons104512253d_evons
dewools1145593dewools
dhobis1236113d_hobis
dholes104914793d_holes
dhooly13457143d_hooly
dhoora1035653d_hoora
dhooras1135943d_hooras
dhooti1035663d_hooti
dhootis1135683d_hootis
dhotis1038973d_hotis
dhows125911223d_h_ows
diatrons939613diatrons
disowns1136733disowns
diurons838823diurons
doblons1037043doblons
dobsons1036203dobsons
donjons1536733donjons
dons56048703d___ons
dooms85321343d__ooms
doors65022133d__oors
downs94918573d__owns
dragons938383dragons
dragoon935283dragoon_
dromons1038193dromons
drools74412813d_rools
droops95110963d_roops
drowns105612333d_rowns
durions839963durions
ethions1038483ethions
falcons1239123falcons
fanions103713073fanions
fanons96115213fa_nons
fashions1437243fashions
gabions102410053gabions
gaboon93211773gaboon_
gadroons1037013gadroons
gallons83015953gallons
galloons9289703galloons
galoots82410793galoots
gammons1237973gammons
garcons102411643garcons
garrons82713463garrons
gascons10289103gascons
gazoos163010223gazoo_s
goons65326773__goons
haboobs1495463haboobs
hadrons113314303hadrons
hagdons1258523hagdons
halons95720713ha_lons
harpoons1337483harpoons
hons77350783__h_ons
hoods95124083__hoods
hoofs115721043__hoofs
hooks125027123__hooks
hoops105621073__hoops
hoots84830253__hoots
horns86125333__horns
jargons1558203jargons
jargoons1644663jargoons
kaons95014853ka__ons
karoos102415803karoo_s
kations114013663kations
kazoos19259113kazoo_s
kroons103711243_kroons
ladhoods1345873ladhoods
ladrons83813193ladrons
lagoon7410483lagoon_
lampoons12266873lampoons
lardons83914493lardons
lardoons9398483lardoons
loons55731723__loons
macons104017243ma_cons
macrons113514893macrons
madzoons20124773madzoons
mahjong2042273mahjong
mahjongs2141813mahjongs
mahoes11313103mah_oes
mahouts1237143mahouts
mahzors2135123mahzors
mammons1048513mammons
manhoods1447243manhoods
maroon83118203maroon_
marrons93216973marrons
mascons113411583mascons
masons83916513ma_sons
matrons93517633matrons
matzoons19105083matzoons
moons75331003__moons
nasions73112383nasions
nations74720563nations
natrons73215663natrons
noons54125283__noons
paeons83915523pa_eons
pardons103817623pardons
parsons93516873parsons
partons94620513partons
patrons93818103patrons
patroons102710603patroons
phonons123310253_phonons
phonos114114793_phonos
phons105221143_ph_ons
photons123814433_photons
platoons1038683platoons
poons75430973__poons
raccoons1265453raccoons
racons84319343ra_cons
racoon83814473racoon_
radons74118533ra_dons
ramsons939563ramsons
rations74123433rations
ratoon64417373ratoon_
rattons73815323rattons
rattoons8327513rattoons
rayons94113343ra_yons
salmons93713263salmons
salons63823693sa_lons
saloon64418023saloon_
saloops93510133saloops
saxhorns1843833saxhorns
schools1249113schools
shooks134515633_shooks
shools94919013_shools
shoon84022013_shoon_
shoos84226363_shoo_s
shoots94619363_shoots
simoons937943simoons
spoons84116023_spoons
swoons94511143_swoons
taboos83815433taboo_s
tachyons1644623tachyons
talions7314113talions
talons64019443ta_lons
tampons112711563tampons
tarpons92612213tarpons
tauons63412673ta_uons
taxons134211503ta_xons
thorns95314103_thorns
thorons104511913_thorons
toons55027533__toons
tycoons1235173tycoons
typhoons1644563typhoons
unhoods1137503unhoods
unhooks1436413unhooks
varooms1248883varooms
waggons1235503waggons
wagons103911213wa_gons
wahoo112413083wahoo__
wanions104011373wanions
wantons103713013wantons
wazoos18288553wazoo_s
whoofs15457243_whoofs
whoops14487863_whoops
yahoo112911543yahoo__
yahooism1643013yahooism
yapons114411773ya_pons
yaupons12345683yaupons
zoons144919693__zoons

Search took 8 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 Limit1340272746.47020715.1
3Display Results2742740.1102490.9
 (SQL Overall)1786912747.00025527.3
 
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.