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

216 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
amorous931113(None) 
abortus9397912abortus
acerous9513332acerous
amadous1038502amadous
amoroso946092amoroso
amorously1446592amorously
amorphous1644652amorphous
anurous7311552anurous
apodous1037402apodous
arborous1047722arborous
aurous64119262a_urous
canorous10310192canorous
clamorous1346192clamorous
glamorous1245102glamorous
humorous1346442humorous
imporous1246302imporous
morons84919542_morons
odorous837662odorous
porous84419482_porous
saporous1039052saporous
savorous1146602savorous
timorous1047432timorous
torous64319032_torous
tumorous1046602tumorous
valorous1147372valorous
vaporous1346482vaporous
aborts84916183abor_ts
acajous1666483acajous
acarpous1245313acarpous
acarus8312193acar_us
acetous9410363acetous
acinous9310933acinous
acoelous1047023acoelous
acorns85013013acor_ns
across8312643a_cross
adipous1037183adipous
adobos9438453adobo_s
adorers84411733adorers
adores74420723ador_es
adorns74212613ador_ns
aeneous739893aeneous
agamous1037943agamous
aggros836553aggro_s
agoras7613343agor_as
agorot7415003agoro_t
agoroth1145143agoroth
airbus848343a_irbus
amadou977613amadou_
amarone9311203amarone
amarones10311353amarones
amatols938183amatols
amazons1836653amazons
ambos95321253am_bo_s
ambries111614553ambries
ambroid1238883ambroid
ambroids1346503ambroids
amerces1149853amerces
amicus103810003am_icus
amidols10457563amidols
amigos94511213amigo_s
amirs75924923amir__s
ammos94815823am_mo_s
amnions93710913amnions
amnios84912523amnio_s
amoebas1135963amoebas
amoks11413553am__oks
amoles84122193amo_les
amoral8314633amor_al
amorini9310353amorini
amorino9310253amorino
amorist9317643amorist
amorists10411333amorists
amort75832203amor__t
amortise10428513amortise
amotions1069843amotions
amounts937043amounts
amour75014853am__our
amours83512663amo_urs
amtracs1198883amtracs
amus65529613am___us
andros7313303andro_s
anoraks1137603anoraks
anserous8410543anserous
anxious1437283anxious
aortas65417783a_ortas
apercus1136573apercus
apivorous1443663apivorous
apologs1038593apologs
aporias9315153aporias
aprons8316993a_prons
apterous10410463apterous
aqueous1636053aqueous
arboreous1144293arboreous
arcus76918863a__rcus
arduous837613arduous
arenous7314183arenous
argus66716543a__rgus
armorers10288973armorers
armories10313653armories
armors85017813armor__s
arouse65019983a__rouse
arrows92813483a_rrows
arsonous846393arsonous
astomous1047213astomous
aureus65314883a_ureus
awmous1157713a_wmous
azygous2043123azygous
borons85520543_borons
camorras12116503camorras
cerous85821203_cerous
chlorous1339223chlorous
chorus115014773chor_us
cirrous93111063cirrous
citrous93112993citrous
comous10816503_comous
cormous11312353_cormous
cornus84816563_cornus
corpus106015293_corpus
cumbrous1446173cumbrous
cuprous1149743cuprous
decorous1138853decorous
dimerous1139323dimerous
dolorous947843dolorous
emerods10137653emerods
emulous937343emulous
enormous1046553enormous
estrous7712533estrous
famous11412393fam__ous
ferrous1049793ferrous
fibrous1237593fibrous
flavorous1544253flavorous
glamourous1352363glamourous
globous1036503globous
glorious946823glorious
hamulous1344923hamulous
harborous1445483harborous
hydrous14197883hydrous
ichorous1346983ichorous
impious1137063impious
improvs1435003improvs
iodous7311503_iodous
joyous16276763_joyous
laborious1144763laborious
laminous1037953laminous
leprous938843leprous
macrons113514893macrons
macros104017013macro_s
maroons92615553maroons
marrons93216973marrons
marrows122911823marrows
matrons93517633matrons
meous76120063_m_eous
miaous8511693_miaous
modus85417203_mo_dus
mojoes15399523_mojoes
mojos145314463_mojo_s
momus96116113_mo_mus
monos75930863_mono_s
moods85224623_mo_ods
mools76027173_mo_ols
moons75331003_mo_ons
moors74923143_mo_ors
moos66051303_mo_o_s
moots75831663_mo_ots
morals85324633_morals
moras76438783_mor_as
morass84614503_morass
morays114613883_morays
morels84820013_morels
mores76249643_mor_es
morgue938113_morgue
morgues1038273_morgues
morions94014643_morions
morns75527443_mor_ns
moron76925423_moro_n
morose85116243_morose
morphs13149433_morphs
morris83814733_morris
morros83714673_morros
morrows12318723_morrows
mors65950063_mor__s
morts75533563_mor_ts
motors84616603_motors
mozos165516333_mozo_s
mucous104411653_mucous
niobous936333niobous
nitrous73512483nitrous
nodous7711333_nodous
numerous1047843numerous
ochrous1237943ochrous
ominous949033ominous
onerous7312973onerous
ozonous1645263ozonous
parous84024163_parous
petrous92714423petrous
pompous1338063pompous
poyous112911623_poyous
ramous8417113ram__ous
ramrods1036583ram_rods
ramulous1045883ramulous
rancorous1145283rancorous
rigorous947373rigorous
riotous739863riotous
serous65023563_serous
sombrous1246613sombrous
sonorous8410413sonorous
sorus54527583_sor_us
tamaraus1096183tamaraus
thorons104511913thorons
toros54336193_toro_s
torus54329763_tor_us
tremorous1145443tremorous
uxorious1544413uxorious
vigorous1245763vigorous
vodous1038603_vodous
wamefous1643763wamefous

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.423422437.4
2DLD Change Limit1340272166.97019229.1
3Display Results2162160.0762842.1
 (SQL Overall)1786912167.46923924.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.