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

206 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
aswoon94701(None) 
swoon85014781_swoon
aboon74918702a_boon
bassoon937612bassoon
saloon64418022saloon
shoon84022012_shoon
soon46240502_s_oon
spoon74719442_spoon
swoons94511142_swoons
swoony12408262_swoony
swoop105213432_swoop
sworn86115312_sworn
swoun84811492_swoun
abloom1039783abloom
achoo10315083achoo_
acorn75616623a_corn
action84719683action
adjoin14107293adjoin
adnoun757033adnoun
adorn64917093a_dorn
adown95611663a_down
adwoman1345433adwoman
adwomen1345683adwomen
aeon45634613a__eon
afoot8420113a_foot
agon56531883a__gon
ajowan1634893ajowan
aloin55227423a_loin
aloof83521573a_loof
amazon1736833amazon
ammono1047373ammono
amnion84812053amnion
ancon75718233a_ncon
anion55028813a_nion
anon46134853a__non
anyon85615223a_nyon
apron7318833a_pron
archon11311753archon
argon65520593a_rgon
arson55118833a_rson
ascot76522513as_cot
ascots85312513ascots
ashcan1135843ashcan
ashen87818673as_hen
ashman1148383ashman
ashmen1168173ashmen
ashore9414613ashore
askoi9507803as_koi
askos95011773as_kos
aslope839013aslope
aslosh966233aslosh
aspen75216093as_pen
assign736783assign
assoil688543assoil
assort64916383assort
astern64815813astern
astony9510523astony
astound845503astound
aswarm11107913aswarm
aswirl935093aswirl
attorn6310793attorn
atwain937813atwain
atween9166613atween
avion84218343a_vion
awn68035913a_w__n
awoke124912003a_woke
awoken13457163a_woken
awol75620673a_w_ol
awols84713523a_wols
axion1211316913a_xion
axon115524303a__xon
azlon144312873a_zlon
azon135725053a__zon
baboon103613913baboon
balloon93711433balloon
basion84315853bas_ion
bassoons1036553bassoons
basswood1494553basswood
bastion9312473bastion
baywood1646443baywood
boon67142173__boon
cardoon104813813cardoon
cartoon94114463cartoon
cashoo11312253cashoo_
cashoos12310793cashoos
cocoon10312263cocoon
coon67248943__coon
croon75522783_croon
dagwood1344833dagwood
dahoon1039053dahoon
dewool1047403dewool
essoin638193essoin
fashion1337843fashion
fatwood1486393fatwood
festoon1037673festoon
gaboon93211773gaboon
gadroon938173gadroon
galloon82910643galloon
gascon9339723gas_con
goon57236173__goon
gossoon865663gossoon
harpoon1238313harpoon
isogon7227543isogon
jargoon1545193jargoon
kroon94514483_kroon
lagoon7410483lagoon
lampoon11267193lampoon
lardoon83410373lardoon
loon47344793__loon
madzoon1996063madzoon
maroon83118203maroon
mascon103612743mas_con
mason74820183mas__on
mastodon1144383mastodon
matzoon1896473matzoon
moon67140813__moon
nasion63914083nas_ion
newton936983newton
noon47134623__noon
passion9310883passion
patroon92811973patroon
poon67341263__poon
raccoon1176163raccoon
racoon83814473racoon
ratoon64417373ratoon
rattoon7359243rattoon
rewon86920583rew_on
reworn98122203reworn
salmon84614183salmon
salon55228553_salon
saloons74415323saloons
saloop84212583saloop
sapwood1366913sapwood
sasswood1294273sasswood
sawlog1035793sawlog
sawn75428163saw__n
scion72214993_scion
scoop95617163_scoop
scoot75729153_scoot
scorn75817453_scorn
seton55223543_seton
shoo75929893_shoo_
shook124920163_shook
shool84523153_shool
shoos84226363_shoos
shoot84235913_shoot
shorn85722183_shorn
shown115216483_shown
simoon858063simoon
sloop76118913_sloop
snood64616163_snood
snook95115573_snook
snool55118643_snool
snoop75317173_snoop
snoot55030143_snoot
solon55026133_solon
son37761953_s__on
sook84933393_s_ook
soot45761063_s_oot
sorn46641063_s_orn
sown75127453_s_own
spoof105019013_spoof
spook115416043_spook
spool75219043_spool
spoons84116023_spoons
spoony114111793_spoony
spoor75016353_spoor
stolon64112073_stolon
stood65517713_stood
stook95218213_stook
stool55619893_stool
stoop75821543_stoop
swain84919053_swain
swan76631313_sw_an
swob95218633_sw_ob
swobs104910893_swobs
swooned11368593_swooned
swooner10358673_swooner
swoops114910923_swoops
swoopy14487283_swoopy
swoosh12195213_swoosh
swop95120503_sw_op
swops105913973_swops
sword95214123_sword
swore84920823_swore
swot75134663_sw_ot
swots85518433_swots
swound10377633_swound
swouns9358243_swouns
teaspoon1044423teaspoon
testoon748373testoon
toon47740633__toon
tycoon1136023tycoon
unsworn1046843unsworn
unwon84512343unw_on
unworn93411333unworn
warworn1357353warworn
wayworn1675293wayworn
won66252063__w_on
woo66949803__woo_
wood85329383__wood
woof106532423__woof
wool76427373__wool
woos76238803__woos
worn75631753__worn
zoon137326983__zoon

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.390458182.1
2DLD Change Limit1127162064.73323814.9
3Display Results2062060.0633269.8
 (SQL Overall)1786912065.18634456.4
 
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.