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

320 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
terrors7311221(None) 
errors63311311_errors
termors94712771termors
terror63811731terror_
error53712232_error_
ferrous1049792ferrous
fervors1336232fervors
horrors1078692horrors
mirrors938622mirrors
perrons93115482perrons
stertors8310922stertors
tearers75218232tearers
tenors63217752te_nors
tensors72712372tensors
termers95414502termers
termor84412512termor_
terras63516972terr_as
terrets72913582terrets
terriers84210822terriers
terries73425632terries
territs72714502territs
terrorise997162terrorise
terrorism1186432terrorism
terrorist988552terrorist
torpors939382torpors
tremors93711222tremors
turgors836832turgors
aerators8315613aerators
arbors84717883_arbors
ardors74416873_ardors
armors85017813_armors
arrows92813483_arrows
barrows123411683barrows
bearers94619593bearers
berries94423553berries
bettors93312473bettors
bevors111610343be_vors
bioterrors1252683bioterrors
borrows12349253borrows
burrers93814493burrers
burros85114993burro_s
burrows12399093burrows
carroms11512403carroms
carrots9714623carrots
censors93611833censors
ceros74726073ce_ro_s
cerous85821203ce_rous
cirrous93111063cirrous
cruors838633_cruors
cursors93910023cursors
debtors1038533debtors
decors94017773de_cors
derries83124623derries
derris73615273derr_is
deterrers10116593deterrers
enrols61213383_enrols
ephors11311403_ephors
ergots74512373_ergots
eros45238453_e_ro_s
errs45622533_e_r_rs
euros54920243_euro_s
evertors1138953evertors
exteriors1647323exteriors
farrows13259783farrows
fearers104815273fearers
ferrels10248623ferrels
ferreous1146033ferreous
ferrets103111393ferrets
ferries103521083ferries
ferrums1265983ferrums
fervor1235643fervor_
fervours1453053fervours
fetors91014473fe_tors
furors9310953_furors
furrows13327793furrows
garrons82713463garrons
genros74211333genro_s
harbors12412413harbors
harrows132611033harrows
hearers104319783hearers
hectors123513263hectors
herders113914123herders
heriots10312063heriots
heritors11310903heritors
heroes94923823he_roes
herons94820543he_rons
heros84930863he_ro_s
herries104025073herries
horror988723horror_
interiors9513563interiors
jeerers14328923jeerers
jerboas1636163jerboas
jerkers18287083jerkers
jerrids15277743jerrids
jerries143817513jerries
jurors1338283_jurors
karroos1139313karroos
kerrias11289513kerrias
kerries113317913kerries
lectors93415763lectors
leprous938843leprous
lessors73610523lessors
marrers93414313marrers
marrons93216973marrons
marrows122911823marrows
mentors9314993mentors
mercers114412773mercers
mergers103813423mergers
merlons93311273merlons
merlots92710123merlots
meteors94610013meteors
metros84217803metro_s
mirror848003mirror_
morros83714673morro_s
morrows12318723morrows
narrows10258843narrows
nerols6914883ne_rols
nervous1037143nervous
nestors73614973nestors
neurons7410443neurons
parlors9312913parlors
parrots9312743parrots
pedros9312183pedro_s
pereons92815003pereons
perform1439273perform
performs1547483performs
periods10312243periods
pernods1038483pernods
perries93226603perries
perron83216623perro_n
persons93717013persons
petrols92913083petrols
petrous92714423petrous
pierrots1044963pierrots
pretors9316803pretors
priors83914483_priors
pyrrols1235403pyrrols
rearers74323563rearers
recross989833recross
rectors93520513rectors
regrows11269153regrows
repros84216003repro_s
reroofs1037943reroofs
retrorse837623retrorse
retros63820193retro_s
sartors7314963sartors
sectors93116443sectors
seisors73212833seisors
seizors16329003seizors
senhors103512123senhors
seniors73413613seniors
senors63620783se_nors
sensors73514633sensors
sergers83815633sergers
serious73616283serious
sermons9311783sermons
serous65023563se_rous
serows96016393se_rows
serries73925353serries
servers103214833servers
servos93812723servo_s
sordors8310003sordors
sorrows10278403sorrows
steerers82511353steerers
stentors839733stentors
stereos74314973stereo_s
sterols7313443ste_rols
stertor7310083stertor_
stirrers8266943stirrers
tabors84517113t_abors
tailors73212393tailors
tarocs84615663t_arocs
taroks106115283t_aroks
taros55640823t_aro_s
tarots66422993t_arots
tarpons92612213tarpons
tarres64723043tarr_es
tarriers83411713tarriers
tarries73324263tarries
tartars73313403tartars
teapots939053teapots
teapoys1235963teapoys
teardrops1263293teardrops
tearer64822903tearer_
teargas837013teargas
tearoom939063tearoom
tearooms1047843tearooms
tears55436463te__ars
teasers75317243teasers
tedders94010233tedders
tedious838443tedious
teemers95012903teemers
teeners74415453teeners
teeters74018303teeters
teflons1036543teflons
telcos8710683telco_s
telfers10299073telfers
telford1145153telford
telfords1244363telfords
tellers73717593tellers
telos55424523te_lo_s
telsons739223telsons
temblors1244463temblors
tempers113513013tempers
tempos103812293tempo_s
tenders83719723tenders
tendons8311473tendons
tenners74014923tenners
tenons62916603te_nons
tenor53620253te_nor_
tenours72610073tenours
tenrecs936033tenrecs
tensor63812673tensor_
tenters73921103tenters
tenuous738483tenuous
tepoys1137543te_poys
terais64023513te_rais
teraohm1244783teraohm
teraohms1343703teraohms
terbias9310743terbias
tercels94110363tercels
terces83921413te_rces
tercets93512443tercets
teredos839183teredos
termer85717253termer_
terms75523473te_r_ms
ternary1038343ternary
ternes65422903te_rnes
ternions838813ternions
terns55226873te_r_ns
terra54419663te_r_ra
terrace93311843terrace
terraces102712253terraces
terrae62915213terr_ae
terraform1443583terraform
terraforms1552583terraforms
terrain7410853terrain
terrains8410323terrains
terrane72814233terrane
terranes82514433terranes
terraria847013terraria
terrases82111483terrases
terreen7257573terreen
terreens8246533terreens
terrene72411033terrene
terrenes82212603terrenes
terret63425623terr_et
terrier73414963terrier
terrify1336353terrify
terrine72517573terrine
terrines82117553terrines
territ63421373terr_it
territory1245093territory
terrorised1184833terrorised
terrorises1087423terrorises
terrorisms12125833terrorisms
terrorists1085613terrorists
terrorize1887083terrorize
terrorizes1987063terrorizes
terrorless1043103terrorless
terry84721873te_r_ry
terser67317823terser_
testers74124543testers
testons7313563testons
tethers103815313tethers
tetrads82910193tetrads
tetras63017623tetr_as
tetris62816293tetr_is
tetrode839343tetrode
tetrodes939093tetrodes
tetryls1034643tetryls
tetters74320473tetters
thermos124610753thermo_s
thorons104511913thorons
throbs118311373t_hrobs
throes97518673t_hroes
throws129715233t_hrows
tiros54524893t_iro_s
toreros7311343torero_s
toros54336193t_oro_s
torous64319033t_orous
torpor839193torpor_
torrs53923563t_or_rs
tors46157383t___ors
torsos64815733torso_s
tourers73512743tourers
tremor84210393tremor_
triers64321523t_riers
triols66117803t_riols
trios55528093t_rio_s
trogs67022603t__rogs
trois57226093t__rois
troops85712783t_roops
trots56629943t__rots
trows88826183t__rows
troys86418613t__roys
tumors8810613t_umors
turbos8910783turbo_s
turbots988023turbots
turgor736863turgor_
turions7311573turions
turkois1135133turkois
turners73912893turners
turnons737863turnons
turrets73010673turrets
tussors7388773tussors
tutors6912333t_utors
tyros85118593t_yro_s
vectors123212593vectors
vendors113510223vendors
verderors1343653verderors
vergers114412633vergers
versers103813523versers
versos93812803verso_s
warriors1135363warriors
wearers104615903wearers
weldors11238003weldors
yarrows13277853yarrows
zeroes154314343ze_roes
zeros144918113ze_ro_s

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.1561145455.1
2DLD Change Limit1340273207.62317581.9
3Display Results3203200.1102909.1
 (SQL Overall)1786913207.88922650.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.