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

258 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
horrors107869(None) 
horror988721horror_
borrows12349252borrows
errors63311312_errors
harbors12412412harbors
harrows132611032harrows
honors94816792ho_nors
hotrods1148282hotrods
mirrors938622mirrors
morros83714672morro_s
morrows12318722morrows
sordors8310012sordors
sorrows10278402sorrows
terrors73112212terrors
torpors939382torpors
abhorrers1442983abhorrers
arbors84717883_arbors
ardors74416873_ardors
armors85017813_armors
arrows92813483_arrows
barrows123411683barrows
boors74325013bo__ors
borders104317533borders
borers85122683bo_rers
borons85520543bo_rons
borrow114310723borro_w
borrowers1474023borrowers
borzois1835833borzois
burrers93814493burrers
burros85114993burro_s
burrows12399093burrows
carroms11512403carroms
carrots9714623carrots
charros124312143charro_s
chorions13310663chorions
churros12427583churro_s
cirrous93111063cirrous
colors86622373co_lors
condors104018573condors
corders104520883corders
cordons104415763cordons
corers85231073co_rers
corkers134118853corkers
cormous11312353cormous
corners94723313corners
cornrows1345313cornrows
corpora1139353corpora
corrals93713853corrals
corridors1245073corridors
corries94026793corries
corrode101310573corrode
corrodes111310333corrodes
corrody13136143corrody
cruors838643_cruors
cursors93910023cursors
dobros93910233dobro_s
doctors1039993doctors
dolors75115313do_lors
donors75115793do_nors
doors65022133do__ors
dormers104313923dormers
dorpers104113173dorpers
dorrs65520593do_r_rs
dorsers83516303dorsers
error53712233_error_
farrows13259783farrows
ferrous1049793ferrous
fervors1336233fervors
foetors1039763foetors
forbore12249673forbore
forcers124215713forcers
fordoes11311963fordoes
forgers115218183forgers
forgoers1236413forgoers
forgoes11311353forgoes
forkers144615783forkers
forlorn1096423forlorn
formers128217953formers
formols12299413formols
forworn13107793forworn
furors9310953_furors
furrows13327793furrows
garrons82713463garrons
gorgers94813643gorgers
gorgons938853gorgons
hadrons113314303hadrons
harbor11410723harbor_
harbours1346923harbours
harlots103413293harlots
harmers124116593harmers
harpers124916203harpers
harriers113712433harriers
harries103525493harries
harrow122610773harro_w
harrowers1555683harrowers
haviors1347383haviors
hearers104319783hearers
hectors123513263hectors
herders113914123herders
heriots10312063heriots
heritors11310903heritors
heroes94923823h_eroes
herons94820543h_erons
heros84930863h_ero_s
herries104025073herries
hirers94518063h_irers
hoarders12307433hoarders
hoards104912623hoar_ds
hoars85925553ho__ars
hoaxers17327133hoaxers
hobbers143512343hobbers
hobnobs1443603hobnobs
hoboes114717443ho_boes
hobos106321353ho_bo_s
hockers163915913hockers
hoers85724923ho__ers
hoggers124512483hoggers
holders113715903holders
hollers103818233hollers
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollows134412333hollows
homers114821973ho_mers
hommos13128503hommo_s
homos105921783ho_mo_s
honers94324973ho_ners
honkers143315233honkers
honor85718623ho_nor_
honorers1139263honorers
honours10339373honours
hoodoos11109293hoodoos
hoods95124083ho__ods
hoofers134513323hoofers
hoofs115721043ho__ofs
hookers144916513hookers
hooks125027123ho__oks
hoopers123616483hoopers
hoopoes121212483hoopoes
hoopoos1298543hoopoos
hoops105621073ho__ops
hoorahs13399603hoorahs
hoorays13418373hoorays
hooters104520473hooters
hoots84830253ho__ots
hoovers134312703hoovers
hopers114222973ho_pers
hoppers143115143hoppers
horahs126313873ho_rahs
horary12310383ho_rary
horas86333103ho_r_as
hordes104921633ho_rdes
horizons2045463horizons
hormone12410503hormone
hormones13311163hormones
hornets104113553hornets
horns86125333ho_r_ns
hornworm1645253hornworm
hornworms1744423hornworms
hornwort1447793hornwort
hornworts1544393hornworts
horrent10313553horrent
horrid10311563horr_id
horrify1635023horrify
horses94729343ho_rses
horstes104516113horstes
horsts95817513ho_rsts
hosers95223963ho_sers
hosiers104212643hosiers
hotdogs1234453hotdogs
hotrod1048803hotro_d
houris94514583hour_is
hours85422393ho__urs
housers104717813housers
hoverers14289023hoverers
hovers124320253ho_vers
howlers133312353howlers
humors11129633h_umors
hurlers103714323hurlers
hurrahs13336773hurrahs
hurrays13386153hurrays
hurriers11358893hurriers
hurries103919653hurries
hurters103413643hurters
hydrops16197413hydrops
hydros13279363hydro_s
hydrous14197883hydrous
jurors1338283_jurors
karroos1139313karroos
kouros1039183kouro_s
lorries74518343lorries
marrers93414313marrers
marrons93216973marrons
marrows122911823marrows
mirror848003mirror_
moors74923143mo__ors
morions94014643morions
morons84919543mo_rons
morrions1077673morrions
morris83814733morr_is
morro73216953morro__
morrow113510093morro_w
mortars93411523mortars
motors84616603mo_tors
narrows10258843narrows
odors64514283_o_dors
orators7313823_orators
orders74315993_orders
ordos65216203_ordo_s
orlons6411013_orlons
orlops847303_orlops
ormers84316143_ormers
orrery936783_orrery
orris54516553_orr_is
orzos143311253_orzo_s
parlors9312913parlors
parrots9312743parrots
perrons93115483perrons
pogroms1237643pogroms
porkers134314933porkers
pornos85015253porno_s
porous84419483po_rous
porters93722703porters
pourers93513673pourers
priors83914483_priors
pyrrols1235403pyrrols
roarers73812743roarers
rotors64917953ro_tors
sartors7314973sartors
shnorrers1243533shnorrers
soarers74118093soarers
sopors85215203so_pors
sordor7310223sordor_
sorgos74514663sorgo_s
sorners73416873sorners
sorrels7310723sorrels
sorrow9339443sorro_w
sorrowers1274763sorrowers
sorters74221133sorters
termors94712773termors
terror63811733terror_
thorons104511913tho_rons
toreros7311343torero_s
toros54336193to_ro_s
torous64319033to_rous
torpor839193torpor_
torrs53923563to_r_rs
torsos64815733torso_s
tourers73512743tourers
turgors836833turgors
warriors1135363warriors
workers144612693workers
wormers124012573wormers
worriers11257813worriers
worries104117133worries
worrits10258683worrits
yarrows13277853yarrows

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 Limit1340272586.84319586.0
3Display Results2582580.0932774.2
 (SQL Overall)1786912587.34224338.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.