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

372 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
terror6381173(None) 
error53712231_error
termor84412511termor
terrors73112211terrors
errors63311312_errors
fervor1235642fervor
horror988722horror
mirror848002mirror
perron83216622perron
stertor7310092stertor
tearer64822902tearer
tenor53620252te_nor
tensor63812672tensor
termer85717252termer
termors94712772termors
terra54419672terr_a
terrae62915212terrae
terras63516972terras
terret63425622terret
terrier73414962terrier
territ63421382territ
terry84721872terr_y
terser67317822terser
torpor839192torpor
tremor84210402tremor
turgor736862turgor
aerator7314853aerator
aerier64823163aerier
aero45435343ae_ro_
anterior8611073anterior
arbor74818113_arbor
ardor64617863_ardor
armor75118063_armor
arrow83414893_arrow
barrow114512773barrow
bearer85323913bearer
berry104521773berr_y
bettor83612223bettor
bevor101510813be_vor
bioterror1152243bioterror
borrow114310733borrow
brrr65312293_brr_r
burrer83718473burrer
burro75018493burro_
burros85114993burros
burrow114610813burrow
carrom10513403carrom
carrot8423123carrot
censor84011293censor
cero66329453ce_ro_
ceros74726073ce_ros
cruor7310453_cruor
cursor84110293cursor
dearer74822803dearer
debtor938333debtor
decor84717573de_cor
derris73615273derris
derry94721373derr_y
deterrer9137013deterrer
eerier64320023eerier
enrol51014283_enrol
ephor10310013_ephor
ergo56420153_ergo_
ergot65422893_ergot
eros45238453_e_ros
err35626533_e_r_r
erred65915673_erred
errs45622533_err_s
euro45325273_euro_
euros54920243_euros
evertor1038723evertor
exterior1547393exterior
eyrir8359653_eyrir
farrow12309983farrow
fearer94820183fearer
ferrel92810203ferrel
ferret93021173ferret
ferric1139993ferric
ferrous1049803ferrous
ferrum1147453ferrum
ferry116020803ferr_y
fervors1336233fervors
fervour1343103fervour
fetor81214533fe_tor
furor8312393_furor
furrow12427743furrow
garron73113493garron
genro64914033genro_
genros74211333genros
harbor11410723harbor
harrow122610783harrow
hearer94323653hearer
hector113312653hector
herder104516463herder
hereof123212373hereof
hereon93914363hereon
heriot9422343heriot
heritor10310563heritor
hero74635783he_ro_
heron85025503he_ron
heros84930863he_ros
herry114922473herr_y
horrors1078693horrors
interior8513113interior
interrow1147143interrow
jeerer13389933jeerer
jerboa1535633jerboa
jerker17369043jerker
jerrid14259143jerrid
jerry155016183jerr_y
juror1239563_juror
karroo10410023karroo
kerria10339923kerria
kerry124916093kerr_y
lector83514993lector
lessor64010603lessor
marrer83716673marrer
marron83717543marron
marrow112812613marrow
mentor8414363mentor
mercer105214203mercer
merer75126233me_rer
merger95016483merger
merlon83012353merlon
merlot83217613merlot
merrier92612303merrier
merry104721493merr_y
meteor84910073meteor
metro74718803metro_
metros84217803metros
mirrors938623mirrors
morro73216953morro_
morros83714673morros
morrow113510093morrow
narrow9269153narrow
nearer64618893nearer
nerol51017813ne_rol
nestor63713423nestor
neuron6310373neuron
parlor8312683parlor
parrot8320663parrot
pedro8313153pedro_
pedros9312183pedros
pereon83517453pereon
perform1439293perform
period9314983period
pernod9310453pernod
perrons93115483perrons
perry105222713perr_y
person83517873person
perter84422283perter
petrol82714063petrol
pierrot948833pierrot
pretor8315753pretor
prior74316173_prior
pyrrol1136273pyrrol
rearer64928913rearer
rector84019753rector
regrow10309883regrow
repro75315913repro_
repros84216003repros
reroof9315003reroof
retro55020953retro_
retros63820193retros
sartor6313883sartor
searer65432023searer
sector83415933sector
seisor63712343seisor
seizor15428533seizor
senhor93010813senhor
senior63214053senior
senor53822803se_nor
sensor63813843sensor
serer55935513se_rer
serger73819743serger
sermon8413553sermon
serow86720443se_row
serry84824123serr_y
server94917713server
servo84516683servo_
servos93812723servos
sordor7310223sordor
sorrow9339443sorrow
steerer73113633steerer
stentor739383stentor
stereo65317913stereo_
stereos74314973stereos
sterner7411913sterner
sterol6613333ste_rol
stertors8310933stertors
stirrer7338233stirrer
tabor75518393t_abor
tailor63412503tailor
tardo65321103tardo_
taro46846913t_aro_
taroc75721643t_aroc
tarok97921073t_arok
taros55640823t_aros
tarot55943933t_arot
tarpon82812803tarpon
tarre55825633tarr_e
tarred74720283tarred
tarres64723043tarres
tarrier74323173tarrier
tarry85422513tarr_y
tartar63214763tartar
tarter64023563tarter
teabox1536013teabox
teapot8416763teapot
teapoy1138113teapoy
tear45242883te__ar
teardrop1153103teardrop
teared75722153teared
tearers75218233tearers
tearier73815613tearier
tearoom939063tearoom
tears55436463tear_s
teary85124053tear_y
teaser65421523teaser
tedder83312163tedder
teemer85515743teemer
teener64717503teener
teeter65420313teeter
teflon937453teflon
telco7511873telco_
telcos8710683telcos
telfer9379903telfer
telford1145163telford
teller63519833teller
teloi54217383te_loi
telos55424523te_los
telson6310293telson
temblor1144093temblor
temper103914093temper
tempo95214973tempo_
tempos103812293tempos
tender74121843tender
tendon7312033tendon
tenner64117103tenner
tenon53320513te_non
tenors63217753tenors
tenour62610733tenour
tenrec837513tenrec
tenser64919433tenser
tensors72712373tensors
tenter64623933tenter
tepoy10312163te_poy
terai53525483te_rai
terais64023513terais
teraohm1244783teraohm
teraph11319093teraph
terbia8311163terbia
terbic10410963terbic
terce75721843te_rce
tercel83612993tercel
terces83921413terces
tercet83624913tercet
teredo7310783teredo
teredos839183teredos
terete6319333terete
terga63315643te_rga
tergal72912833tergal
tergum937933tergum
term66233153te_r_m
termed94816703termed
termers95414503termers
termly1138433termly
terms75523473te_rms
tern46134803te_r_n
ternary1038343ternary
terne56426153te_rne
ternes65422903ternes
ternion739493ternion
terns55226873te_rns
terrace93311843terrace
terraform1443603terraform
terrain7410853terrain
terrane72814233terrane
terraria847023terraria
terreen7257573terreen
terrene72411033terrene
terrets72913583terrets
terriers84210823terriers
terries73425633terries
terrify1336353terrify
terrine72517573terrine
territory1245113territory
territs72714503territs
terrorise997173terrorise
terrorism1186433terrorism
terrorist988563terrorist
terrorize1887083terrorize
terse55026823te_rse
tester64227153tester
teston6313303teston
tether93716103tether
tetra53417953tetr_a
tetrad73612053tetrad
tetras63017623tetras
tetri52716453tetr_i
tetris62816293tetris
tetrode839343tetrode
tetryl935693tetryl
tetter64322453tetter
therefor1494453therefor
thereof13168063thereof
thereon10199263thereon
thermos124610753thermos
thoro86217873thoro_
thoron94713903thoron
thro77726423t_hro_
throb109816853t_hrob
throe89321423t_hroe
throw118719733t_hrow
tiro46832373t_iro_
tiros54524893t_iros
tor39261683t___or
torero6313203torero_
toreros7311343toreros
toro48045683t_oro_
toros54336193t_oros
torot56139943t_orot
torpors939383torpors
torr45630903t_or_r
torrid7311853torrid
torrs53923563torr_s
torso56922143torso_
torsos64815733torsos
tourer64115073tourer
tremors93711233tremors
trier54328533t_rier
trio45233343t_rio_
triol55521363t_riol
trios55528093t_rios
trod57627953t__rod
trog57628213t__rog
troop76417533t_roop
trooz145016153t_rooz
trop66833303t__rop
trot46351313t__rot
trow78031423t__row
troy77429683t__roy
truer54916643t_ruer
tumor71110693t_umor
turbo71015043turbo_
turbos8910783turbos
turbot8914263turbot
turgors836833turgors
turion6313163turion
turner63914613turner
turnon638193turnon
turret63121853turret
tussor6378233tussor
tutor5712493t_utor
tyro76622363t_yro_
tyros85118593t_yros
ulterior845463ulterior
vector113212063vector
vendor10359803vendor
verderor1243203verderor
verger104315703verger
verier94620963verier
verser94516963verser
verso85314633verso_
versos93812803versos
warrior1045363warrior
wearer94319413wearer
weldor10317653weldor
xerox1138623xe_rox
yarrow12287943yarrow
zero134822473ze_ro_
zeros144918113ze_ros

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.390458182.1
2DLD Change Limit1127163725.70319764.3
3Display Results3723720.1103381.8
 (SQL Overall)1786913726.20328807.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.