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

260 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
honours1033937(None) 
honors94816791hono_rs
honour94710861honour_
colours95913442colours
concours1239472concours
concurs11311472concurs
contours1039652contours
dolours8438822dolours
donors75115792dono_rs
honers94324972hon_ers
honkers143315232honkers
honor85718622hono_r_
honorers1139262honorers
honoured1236312honoured
honourer1146242honourer
honourers1245572honourers
hours85422392h__ours
humours1286432humours
odours7418252_odours
tenours72610072tenours
adnouns835453adnouns
amours83512663_amours
arbours93910043arbours
ardours8368883ardours
armours9389853armours
bonders104120663bonders
bonducs1235553bonducs
boners84825433bon_ers
bonkers134015303bonkers
bonobos1136393bonobos
bonus75324323bon_u_s
boors74325013bo_o_rs
candours11408643candours
canoers94318373canoers
clours85215093_clours
colors86622373colo_rs
colour85915093colour_
comous10816503comou_s
concourse1345803concourse
concur10411103concur_
concuss1138063concuss
condors104018573condors
confers124120093confers
congers104223233congers
congous103615083congou_s
coniums11311863coniums
conjure16109073conjure
conjures17119913conjures
conkers133721043conkers
conners94023113conners
conoids10813883conoids
conquers1938223conquers
consuls92412313consuls
contour939973contour_
conus76726533con_u_s
cooers84324563co_oers
copouts11311083copouts
detours858043detours
devours1166643devours
dolors75115313dolo_rs
dolour75710133dolour_
donor64418193dono_r_
donuts7410583don_uts
doors65022133do_o_rs
downpours1542533downpours
dyvours1453183dyvours
ecotours1044463ecotours
favours13437093favours
flours94414053_flours
fondues11399313fondues
fondus105210943fondu_s
fours85521493__fours
giaours834573giaours
goners74420173gon_ers
gonofs10459863gono_fs
gonophs1344453gonophs
handers114224333handers
handouts1238233handouts
hangars114313493hangars
hangers113120813hangers
hangouts1236183hangouts
hangups1364813hangups
hankers144218133hankers
harbours1346923harbours
haviours1443843haviours
heinous1038853heinou_s
hinders113718503hinders
hingers113420213hingers
hinters103719583hinters
hoars85925553h__oars
hoaxers17327133hoaxers
hobbers143512343hobbers
hobnobs1443603hobno_bs
hoboes114717443hobo_es
hobos106321353hobo__s
hockers163915913hockers
hocus104715203ho_cu_s
hoers85724923h__oers
hoggers124512483hoggers
hognoses12108133hognoses
hognuts1134183hognuts
hokums1533923ho_kums
holders113715903holders
holdouts1245493holdouts
holdups1333593holdups
hollers103818233hollers
homburg1543073homburg
homburgs1642733homburgs
homers114821973ho_mers
homos105921783homo__s
honans94814503hon_ans
honchos15369573honchos
hondas10313353hon_das
hondles113614523hondles
honer85332093hon_er_
hones88144493hon__es
honeys124016083hon_eys
hongies112716473hongies
hongs95126203hon__gs
honker134117463honker_
honkeys17439513honkeys
honkies143015143honkies
honks125124523hon__ks
honorary1445803honorary
honored11310123honored
honoree10412113honoree
honorees1148773honorees
honorer1039673honorer
honouring1336883honouring
hons77350783hon___s
hoods95124083ho_o_ds
hooeys125512313ho_oeys
hoofers134513323hoofers
hoofs115721043ho_o_fs
hookas135312493ho_okas
hookers144916513hookers
hooks125027123ho_o_ks
hookups1633263hookups
hoopers123616483hoopers
hoops105621073ho_o_ps
hooters104520473hooters
hoots84830253ho_o_ts
hoovers134312703hoovers
hooves124815483ho_oves
hopers114222973ho_pers
hoppers143115143hoppers
hornpouts1443453hornpouts
horrors1078693horrors
hosers95223963ho_sers
hosiers104212643hosiers
hotspurs1342843hotspurs
hounders123111713hounders
hour75827313h__our_
houri85915253h__ouri
houris94514583h__ouris
housers104717813housers
hovers124320253ho_vers
howlers133312353howlers
humors11129633humo_rs
humour11116753humour_
hungers114013303hungers
hunkers143314333hunkers
hunters103915733hunters
incurs83012283_incurs
inpours936423inpours
iodous7311503iodou_s
ioniums938303ioniums
ionomers1038503ionomers
ionones7313883ionones
joyous16276763joyou_s
knaurs10466963_knaurs
knouts10438313_knouts
knurs94511153_kn_urs
labours9349893labours
langurs889103langurs
loners64225813lon_ers
longers84819543longers
lours55125293__lours
manors84420883mano_rs
minors85117103mino_rs
mohurs1135933mo_hurs
mongers104217273mongers
monomers12311033monomers
monos75930863mono__s
mooners94015343mooners
moors74923143mo_o_rs
motors84616603moto_rs
nodous7711333nodou_s
noirs55615463__noirs
nonjury1744033nonjury
nonwars10109003nonwars
nouns56717313__nouns
nous46136983__nou_s
occurs10136553_occurs
odors64514283_odo_rs
odour64710493_odour_
onos46229003_ono__s
onus45826813_on_u_s
ours47237563___ours
ozonous1645263ozonou_s
pandours11317993pandours
phonons123310253phono_ns
phonos114114793phono__s
ponders103618843ponders
porous84419483porou_s
poseurs9378293poseurs
pours74623183__pours
poyous112911623poyou_s
pronouns1047203pronouns
rancours1076713rancours
repours9310233repours
rigours8207003rigours
rondure837313rondure
rondures937713rondures
rotors64917953roto_rs
rumours976373rumours
runouts737353runouts
santours837183santours
santurs7310763santurs
sapours93610623sapours
savours10389343savours
scours84913593_scours
senors63620793seno_rs
snouts64915873_snouts
sojourn1442893sojourn
sojourns1542313sojourns
sonars64818973son_ars
sonders83820713sonders
sooners73916643sooners
sopors85215203sopo_rs
sours55230503__sours
stours65015633_stours
tabours94110093tabours
tenors63217753teno_rs
tenour62610733tenour_
toners64128003ton_ers
tongers84116013tongers
tongues879693tongues
tonners73816403tonners
tonsure758783tonsure
tonsures869133tonsures
tonus56324303ton_u_s
torous64319033torou_s
tours55325893__tours
tumours976753tumours
valours10248743valours
vapours12277463vapours
velours10278083velours
venous93713193venou_s
vigours11285483vigours
vinous93914173vinou_s
vodouns1134763vodouns
vodous1038603vodou_s
voyeurs1332423voyeurs
wonders113315993wonders
wonners104312813wonners
wooers93712443wo_oers
yonkers14379823yonkers
yours85217883__yours
zoners155115993zon_ers

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 Limit1340272607.09318895.7
3Display Results2602600.1102363.6
 (SQL Overall)1786912607.60923484.2
 
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.