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

308 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
honour9471086(None) 
honor85718621hono_r
honours10339371honours
colour85915092colour
concur10411102concur
contour939972contour
dolour75710132dolour
donor64418192dono_r
honer85332092hon_er
honker134117462honker
honorer1039672honorer
honors94816792honors
honoured1236312honoured
honourer1146242honourer
hour75827312h__our
humour11116752humour
odour64710492_odour
tenour62610732tenour
adnoun757033adnoun
amour75014853_amour
arbour84211333arbour
ardour74110903ardour
armour84411853armour
bonder95324783bonder
bonduc1136603bonduc
boner75133083bon_er
bonier84321993bonier
bonobo1037143bonobo
bonus75324323bon_us
bonzer175313673bonzer
boor66130683bo_o_r
candour104210243candour
canoer85121073canoer
clour76617283_clour
color76123743colo_r
colours95913443colours
comous10816503comous
concours1239473concours
concurs11311473concurs
condor94616973condor
confer114018683confer
conger95024273conger
congou94313243congou_
congous103615083congous
conium10415313conium
conjure16109073conjure
conker124721553conker
conner84423963conner
conoid9818883conoid
conquer1838623conquer
consul82312303consul
contours1039653contours
conus76726533con_us
cooer74831013co_oer
copout10418783copout
detour778193detour
devour1076703devour
dolor67617963dolo_r
dolours8438823dolours
donors75115793donors
donut6324513don_ut
door56928513do_o_r
dour56330433__dour
downpour1443003downpour
dyvour1393343dyvour
ecotour944363ecotour
favour12438333favour
flour84916453_flour
fonder104120063fonder
fondu96013973fondu_
fondue104510493fondue
fondus105210943fondus
four76226863__four
giaour735363giaour
goner66025163gon_er
gonium949803gonium
gonof95218653gono_f
gonofs10459863gonofs
gonoph1235403gonoph
hander104526433hander
handout11314103handout
hangar104114513hangar
hanger104023253hanger
hangout11411393hangout
hangul1049213hangul
hangup1277293hangup
hanker134622093hanker
harbour1247053harbour
haviour1354823haviour
heinous1038853heinous
hinder104120063hinder
hinger104723333hinger
hinter94021303hinter
hoar76729163h__oar
hoaxer16348563hoaxer
hobber134114633hobber
hobnob1335133hobno_b
hobnobs1443603hobnobs
hobo97026083hobo__
hoboed124511683hoboed
hoboes114717443hoboes
hobos106321353hobo_s
hocker155118563hocker
hocus104715203ho_cus
hoer76533983h__oer
hogger114615083hogger
hognose11117243hognose
hognut1039413hognut
hokier134214033hokier
hokku1135483hokku_
hokum1436773ho_kum
holder104619653holder
holdout11510903holdout
holdup1245183holdup
holier94921623holier
holler93520613holler
homburg1543073homburg
homer105828453ho_mer
homier116416993homier
homo96126473homo__
homos105921783homo_s
hon67759383hon___
honan85319773hon_an
honans94814503honans
honcho14389383honcho
honda9414983hon_da
hondas10313353hondas
hondle103914523hondle
hone77549323hon__e
honed95332263hon_ed
honers94324973honers
hones88144493hon_es
honest94822423honest
honey115629913hon_ey
honeys124016083honeys
hong85833953hon__g
hongi96715873hon_gi
hongs95126203hon_gs
honied104818393honied
honing103421503honing
honk116931193hon__k
honked144517913honked
honkers143315233honkers
honkey165113823honkey
honkie133011673honkie
honks125124523hon_ks
honky156218523hon_ky
honorary1445803honorary
honored11310123honored
honoree10412113honoree
honorers1139263honorers
honourers1245573honourers
honouring1336883honouring
hons77350783hon__s
hooch135813703ho_och
hood85132333ho_o_d
hoods95124083ho_ods
hoody124919723ho_ody
hooey114926603ho_oey
hoof106036583ho_o_f
hoofer124014953hoofer
hoofs115721043ho_ofs
hook116133283ho_o_k
hooka125513903ho_oka
hooker134820173hooker
hooks125027123ho_oks
hookup1534423hookup
hooky155220263ho_oky
hooly115022223ho_oly
hoop96129983ho_o_p
hooper114518313hooper
hoops105621073ho_ops
hoot75752103ho_o_t
hooter94123933hooter
hoots84830253ho_ots
hooty115022443ho_oty
hoover124314433hoover
hoper105829143ho_per
hopper134218483hopper
hornier103012463hornier
hornpout1356703hornpout
horror988723horror
hoser811529763ho_ser
hosier94219613hosier
hotspur1242553hotspur
hotter94720083hotter
hounder113412233hounder
houri85915253h__ouri
hours85422393h__ours
houser95322283houser
hover115524133ho_ver
howler123514313howler
humor101110513humo_r
humours1286433humours
hunger104015203hunger
hunker133917673hunker
hunter94817773hunter
incur72212253_incur
inpour837063inpour
iodous7311503iodous
ionium8610923ionium
ionomer939833ionomer
ionone6313443ionone
joyous16276763joyous
knaur9508253_knaur
knout95018263_knout
knur85311973_kn_ur
kronor10417233krono_r
kronur10415313kron_ur
labour84210933labour
langur7109303langur
loner55431043lon_er
longer75823203longer
lour45430683__lour
manor78023933mano_r
minor74920063mino_r
mohur1036513mo_hur
monger94418333monger
mono66036723mono__
monody1238243monody
monomer11311893monomer
monos75930863mono_s
mooner85317833mooner
moor66628553mo_o_r
motor75317293moto_r
nodous7711333nodous
noir46722433__noir
nonjury1744033nonjury
nonpar8168993nonpar
nonpoor956483nonpoor
nonwar9159423nonwar
nor38048823__no_r
noun45724183__noun
nous46136983__nous
occur9137323_occur
odor55718093_odo_r
odours7418253_odours
onium73115533_onium
ono36838033_ono__
onos46229003_ono_s
onus45826813_on_us
our36042893___our
ozonous1645263ozonous
pandour10408213pandour
phonier122710633phonier
phono104917023phono__
phonon114012033phono_n
phonons123310253phonons
phonos114114793phono_s
ponder94521693ponder
poor65630223po_o_r
porous84419483porous
poseur8419403poseur
pour611527473__pour
poyou102611523poyou_
poyous112911623poyous
pronoun939033pronoun
rancour987133rancour
repour8310993repour
rigour7258023rigour
rondure837313rondure
rotor55519733roto_r
rumour8127383rumour
runout6414873runout
santour737373santour
santur6311273santur
sapour83812373sapour
savour94110703savour
scour75315533_scour
senor53822803seno_r
snout54530633_snout
sojourn1442893sojourn
sonar56523423son_ar
sonder73623523sonder
sooner64220463sooner
sopor74016493sopo_r
sour45935893__sour
stour54916743_stour
tabour84011323tabour
tenor53620253teno_r
tenours72610073tenours
toner55336243ton_er
tonger74719683tonger
tongue7410093tongue
tonier65520713tonier
tonner64819203tonner
tonsure758783tonsure
tonus56324303ton_us
torous64319033torous
tour45530383__tour
tumour8137403tumour
valour93010373valour
vapour11378873vapour
velour9328763velour
venous93713193venous
vigour10256803vigour
vinous93914173vinous
vodou939343vodou_
vodoun1036233vodoun
vodous1038603vodous
voyeur1232863voyeur
wonder103617813wonder
wonner95114443wonner
wooer84316693wo_oer
yonder103214133yonder
yonker134110853yonker
your78623433__your
zoner144520343zon_er

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.376475242.0
2DLD Change Limit1127163085.43620735.1
3Display Results3083080.0963208.3
 (SQL Overall)1786913085.90830245.6
 
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.