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

145 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
odorous83766(None) 
amorous9311132amorous
dolorous947842dolorous
inodorous1044532inodorous
ochrous1237942ochrous
odious749932od_ious
odorful1143482odorful
odorously1345272odorously
odors64514282odor__s
onerous7312972onerous
ordurous944752ordurous
ozonous1645262ozonous
porous84419482_porous
sonorous8410412sonorous
torous64319032_torous
abortus9397913abortus
acerous9513333acerous
adipous1037183adipous
adobos9438453adobo_s
adorers84411733adorers
adores74420723ador_es
adorns74212613ador_ns
anurous7311553anurous
apodous1037403apodous
arborous1047723arborous
aurous64119263_aurous
borons85520543_borons
canorous10310193canorous
cerous85821203_cerous
chlorous1339223chlorous
chorus115014773chor_us
cirrous93111063cirrous
citrous93112993citrous
comous10816503_comous
cormous11312353_cormous
cornus84816563_cornus
corpus106015293_corpus
cuprous1149743cuprous
decorous1138853decorous
dobros93910233dobro_s
dodoes85716103_dodoes
dodos75819393_dodo_s
dojos135111793_dojo_s
dolors75115313_dolors
dolour75710133_dolour
dolours8438823_dolours
donors75115793_donors
doodoos9107623doodoos
doofus1036163_doofus
dooms85321343_do_oms
doors65022133_do_ors
doowops1363943doowops
dorbug1034953_dorbug
dorbugs1132983_dorbugs
dories75232363_dories
dorks105724443_dor_ks
dormouse1144243_dormouse
dorms85723843_dor_ms
dorps85419223_dor_ps
dorrs65520593_dor_rs
dors56747603_dor__s
dorsum947623_dorsum
drools74412813_drools
droops95110963_droops
drops85719503_d_rops
dross65418093_d_ross
drouk1039433_d_rouk
drouks1137123_d_rouks
durocs9569703_durocs
duros65422693_duro_s
enormous1046553enormous
estrous7712533estrous
ferrous1049803ferrous
fibrous1237593fibrous
globous1036503globous
glorious946823glorious
godroons1045363godroons
goitrous945763goitrous
humorous1346443humorous
hydrous14197883hydrous
ichorous1346983ichorous
idoneous944573idoneous
imporous1246303imporous
iodous7311503_iodous
joyous16276763_joyous
leprous938843leprous
malodorous1352653malodorous
morons84919543_morons
motorbus1244443motorbus
niobous936333niobous
nitrous73512483nitrous
nodous7711333_nodous
nodulous944733nodulous
nonporous1147153nonporous
notorious946213notorious
obolus8378813obo_lus
obvious1244823obvious
ocherous1347013ocherous
ochreous1343773ochreous
octrois938333octrois
odeons739023od_eons
odiferous1343943odiferous
odor55718093odor___
odorant8411393odorant
odorants946043odorants
odored8399223odor_ed
odorize1737403odorize
odorizes1837213odorizes
odorless934173odorless
odour64710493od__our
odourful1251713odourful
odours7418253odo_urs
oestrous869923oestrous
oloroso744613oloroso
olorosos844113olorosos
ominous949033ominous
operons91411743operons
osmious936003osmious
osmous8138183o_smous
osseous736053osseous
outrows10311403outrows
ovolos9257203ovolo_s
parous84024163_parous
petrous92714423petrous
podagrous1343473podagrous
ponderous1267273ponderous
poyous112911623_poyous
rigorous947373rigorous
riotous739863riotous
saporous1039053saporous
savorous1146603savorous
serous65023563_serous
sombrous1246613sombrous
sorus54527583_sor_us
thorons104511913thorons
timorous1047433timorous
toros54336193_toro_s
torus54329763_tor_us
tumorous1046603tumorous
uxorious1544413uxorious
valorous1147373valorous
vaporous1346483vaporous
vigorous1245763vigorous
vodous1038603_vodous
wondrous1246823wondrous

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.406440125.6
2DLD Change Limit1340271456.62320236.6
3Display Results1451450.0463152.2
 (SQL Overall)1786911457.07525256.7
 
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.