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

436 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
odours741825(None) 
odors64514281odo_rs
odour64710491odour_
amours83512662amours
ardours8368882ardours
clours85215092clours
colours95913442colours
doers65225712_doers
dolours8438822dolours
doors65022132_doors
dorrs65520592_dorrs
dors56747602_do_rs
doums85417642_doums
dour56330432_dour_
doura66518662_doura
douras75016722_douras
flours94414052flours
fours85521492_fours
honours10339372honours
hours85422392_hours
iodous7311502iodou_s
lours55125292_lours
nodous7711332nodou_s
occurs10136552occurs
odeums9367312odeums
odious749932odiou_s
odiums9337942odiums
odor55718092odo_r_
ours47237562__ours
pours74623182_pours
scours84913592scours
sours55230502_sours
stours65015632stours
tours55325892_tours
vodouns1134762vodouns
vodous1038602vodou_s
yours85217882_yours
adders84315703adders
adjourn1563433adjourn
adjourns1662863adjourns
adjure1435843adjure
adjures1536233adjures
adnouns835453adnouns
adobes94411533adobes
adobos9438453adobos
adonis7314063adonis
adopts998083adopts
adore65723673ado_re
adorers84411733adorers
adores74420723adores
adorn64917093ado_rn
adorns74212613adorns
ados57633513ado__s
amour75014853amour_
apodous1037403apodou_s
arbours93910043arbours
ardors74416873ardo_rs
ardour74110903ardour_
armours9389853armours
augurs7399963augurs
blurs74619083_blurs
boars75229603_boars
boors74325013_boors
boudoirs1143703boudoirs
bourg84113843_bourg
bourgs9459993_bourgs
bourn75518483_bourn
bourns84114063_bourns
bourse84414333_bourse
bouts75131313_bouts
burs65847423__burs
candours11408643candours
choirs114911883choirs
chorus115014773chorus
clouds94612353clouds
clour76617283clour_
clouts87017203clouts
codders114114453codders
coders95426983cod_ers
codgers115113933codgers
codons96119463codo_ns
coirs75221053_coirs
colors86622373colo_rs
colour85915093colour_
comous10816503comou_s
concours1239473concours
concurs11311473concurs
condors104018573condo_rs
contours1039653contours
cooers84324563cooers
copouts11311083copouts
cors66656443_co_rs
coups95522473_coups
course85117783_course
court75532773_court
courts84216173_courts
croups104312553croups
cruors838633cruors
curs65645543__curs
daubs85014563_daubs
dauts67822243_dauts
dears65736883_dears
deers64930523_deers
demurs939773demurs
detours858043detours
devours1166643devours
doats65224883_doats
dobra85013103_dobra
dobras94811913_dobras
dobro84412213_dobro
dobros93910233_dobros
docks126022313_docks
docs75631153_do_cs
dodders105511793dodders
dodgers105213823dodgers
dodoes85716103dodo_es
dodos75819393_dodos
doer57734703_doer_
does56554473_do_es
doffs125614333_doffs
doges75630163_doges
dogs66440153_do_gs
doits66223673_doits
dojos135111793_dojos
doles67843753_doles
dolls66126923_dolls
dolors75115313dolors
dolour75710133dolour_
dols56943053_do_ls
dolts65626313_dolts
domes85735563_domes
doms76239573_do_ms
donas65926473_donas
dongs76525813_dongs
donors75115793donors
dons56048703_do_ns
donuts7410583donuts
doofus1036163doofus
dooms85321343_dooms
door56928513_door_
doozers17419293doozers
dopas85019063_dopas
dopers95522483dopers
dopes84935043_dopes
dor47253923_do_r_
dore56353303_do_re
dork96531463_do_rk
dorks105724443_dorks
dorm76834633_do_rm
dorms85723843_dorms
dorp76028053_do_rp
dorps85419223_dorps
dorr56627723_do_rr
dorsa64617283_do_rsa
dory85836233_do_ry
dos48062313_do__s
dosers75723633dosers
doses65938503_doses
doss56235043_do_ss
doters74423913doters
dotes65836693_dotes
dots55647663_do_ts
doubt8720093_doubt
doubts968733_doubts
douce85518423_douce
dough105217383_dough
doughs115912933_doughs
doula65717773_doula
doulas75114993_doulas
doum76226673_dou_m
douma85817703_douma
doumas95314813_doumas
dourah10479813_dourah
dourahs11487253_dourahs
dourer74215273_dourer
dourest8312943_dourest
dourly103210433_dourly
douse66329723_douse
dousers84817273_dousers
douses74928933_douses
doux125817983_dou_x
doves94728153_doves
dowers104523293dowers
downs94918573_downs
dowry126312483_dowry
dows85941053_do_ws
dozers164815423dozers
dozes155226303_dozes
drouks1137123drouks
drubs85913833_drubs
drugs75214653_drugs
drums85415873_drums
dubs78432193_d_ubs
duds65530143_d_uds
dues56045503_d_ues
dugs614832283_d_ugs
duns55140433_d_uns
duos56728133_d_uos
dups75929513_d_ups
dura55232113_d_ura
duras65727723_d_uras
dure56341813_d_ure
dures65635923_d_ures
durn56127623_d_urn
durns64819863_d_urns
duro56228023_d_uro
duros65422693_d_uros
durr55624353_d_urr
durrs65519993_durrs
durst66125173_d_urst
dyers96617133_dyers
dyvours1453183dyvours
ecotours1044463ecotours
edgers84413913edgers
favours13437093favours
femurs1136713femurs
floors94112353floors
flour84916453flour_
floury12449573floury
flouts94315273flouts
fluors94311373fluors
fodders124010753fodders
foldouts1244793foldouts
fouls87221433_fouls
four76226863_four_
furs76735043__furs
gaurs66317993_gaurs
ghouls1036043ghouls
giaours834573giaours
glouts74414713glouts
godowns1234673godowns
goers65520253_goers
gourd71011903_gourd
gourds8108253_gourds
gouts64826173_gouts
groups94210513groups
grouts75015613grouts
hoars85925553_hoars
hoers85724923_hoers
holdouts1245493holdouts
honors94816793hono_rs
honour94710863honour_
hour75827313_hour_
houri85915253_houri
houris94514583_houris
humours1286433humours
idlers74012813idlers
idols65514133ido_ls
incurs83012283incurs
indoors838553indoors
inpours936423inpours
jodhpurs214933jodhpurs
jouks165612343_jouks
joyous16276763joyou_s
khoums1594013khoums
knaurs10466963knaurs
knouts10438313knouts
knurs94511153_knurs
kors85933013_ko_rs
kouros1039183_kouros
labours9349893labours
lemurs837253lemurs
lodgers95113833lodgers
louis57322323_louis
loups75319623_loups
lour45430683_lour_
loury85716753_loury
louts56330273_louts
meous76120063meou_s
modus85417203mod_u_s
mohurs1135933mohurs
moors74923143_moors
mors65950063_mo_rs
motors84616603moto_rs
moues75732843_moues
mourn77215013_mourn
mourns84111013_mourns
nodders94410263nodders
nodus66315993nod_u_s
noirs55615463_noirs
nouns56717313_nouns
nous46136983_nou_s
oakums1264153oakums
oars46846033__oars
oaters65029793oaters
oboes75717713obo_es
oboles83815833oboles
obols73715863obo_ls
obolus8378813obolus
occur9137323occur_
ochers113915303ochers
ockers123813903ockers
odahs95610083od_ahs
odas57230263od__as
odder74515393odder_
odds68919923od__ds
odeons739023odeons
odes57243243od__es
odeum84610543odeu_m
odists749853odists
odium83413033odiu_m
odored8399223odored
odorous837663odorous
odourful1251713odourful
ods47546213od___s
odyles10348563odyles
odyls9428653od_yls
offers12349963offers
ogdoads1042993ogdoads
oglers74313183oglers
oilers64721193oilers
oleums8358783oleums
ombers104214403ombers
omers76923193o_mers
onos46229003ono__s
onus45826813o_nu_s
oodles73517183oodles
oohs75220693o_o_hs
oops65232673o_o_ps
oots46446443o_o_ts
oozes145418713o_ozes
opiums10307073opiums
opus66420593o_pu_s
orders74315993orders
ordos65216203ordo__s
ordure756813ordure
ordures856473ordures
ormers84316143ormers
ors35750113__o_rs
osiers63412793osiers
osmous8138183osmou_s
others93918003others
ottars64112223ottars
otters64021513otters
ouds56430103__ouds
our36042893__our_
outdoers937513outdoers
outdoors936433outdoors
outers64230173outers
outpours1036683outpours
outs45746963__outs
overs85224793o_vers
ovoids10456923ovoids
ovolos9257203ovolos
owners94210703owners
oxters134813273oxters
oyers87620883o_yers
ozones1539393ozones
padouks1434873padouks
pandours11317993pandours
pious74621273piou_s
podiums12227633podiums
porous84419483porou_s
poseurs9378293poseurs
poufs105616063_poufs
pour611527473_pour_
pouts75530323_pouts
poyous112911623poyou_s
purs65641043__purs
recurs83315803recurs
redouts81411663redouts
repours9310233repours
rigours8207003rigours
roars55622243_roars
rotors64917953roto_rs
roues56039353_roues
roups75118903_roups
routs57133413_routs
rumours976373rumours
sapours93610623sapours
savours10389343savours
scaurs85512053scaurs
scour75315533scour_
scouts84817943scouts
shoers94518333shoers
shouts94017723shouts
siddurs934173siddurs
sieurs659043sieurs
slurs54123373_slurs
snouts64915873snouts
soars54732513_soars
sodiums10177213sodiums
sodoms989673sodo_ms
sojourn1442893sojourn
sojourns1542313sojourns
sopors85215203sopo_rs
sordors8310003sordo_rs
sorus54527583_sorus
souks94820523_souks
souls55127363_souls
soups75322943_soups
sour45935893_sour_
sous46947213_sou_s
spoors84014033spoors
spouts85115113spouts
spurs74621523_spurs
stoups85313273stoups
stour54916743stour_
stoure64814943stoure
stoures74614163stoures
stoury9529943stoury
stouts65019003stouts
sudors7311103sudo_rs
swouns9358243swouns
tabours94110093tabours
tenours72610073tenours
thous86017263thou_s
torous64319033torou_s
torrs53923563_torrs
tors46157383_to_rs
torus54329763_torus
tour45530383_tour_
touts54830393_touts
trouts66116633trouts
tsouris735153tsouris
tumours976753tumours
udders83911293udders
udons65411463udo_ns
udos56619903udo__s
undoers82910583undoers
valours10248743valours
vapours12277463vapours
velours10278083velours
vigours11285483vigours
vodou939343vodou__
vodoun1036233vodou_n
voduns1035053vod_uns
voudouns1243203voudouns
voyeurs1332423voyeurs
vrouws12494743vrouws
wooers93712443wooers
yodlers11298923yodlers
your78623433_your_
yourn87512773_yourn
yous76230653_you_s
zouks184410503_zouks

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.393454684.5
2DLD Change Limit1127164365.62320045.5
3Display Results4364360.1403114.3
 (SQL Overall)1786914366.15629027.1
 
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.