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

197 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
stertor731009(None) 
stentor739381stentor
stertors8310931stertors
assertor865722assertor
evertor1038722evertor
sartor6313882s_artor
sector83415932s_ector
starter73817882starter
stator64015482st_ator
stentors839752stentors
stereo65317912stereo_
stereos74314972stereos
sterner7411912sterner
sterol6613332ster_ol
termor84412512_termor
terror63811732_terror
abettor956193abettor
aerator7314843_aerator
alerter72111513alerter
anterior8611063anterior
aspersor10336233aspersor
assentor865293assentor
asserter877573asserter
assertors965973assertors
attestor845463attestor
averter102410553averter
bettor83612223_bettor
creator93714443creator
debtor938333_debtor
detector11278323detector
ejector16378603ejector
elector93313263elector
erector93513813erector
error53712233__error
evertors1138953evertors
exterior1547383exterior
fervor1235643_fervor
fetor81214533_fe_tor
foetor939563foe_tor
hector113312653_hector
heritor10310563_heritor
interior8513103interior
invertor11238973invertor
lector83514993_lector
literator948683literator
mentor8414363_mentor
nestor63713423_nestor
operator10310093operator
overtop1237723overtop
patentor1046373patentor
perter84422283_perter
posterior1147843posterior
pretor8315753pre_tor
questor16146633questor
rector84019753_rector
rhetor938063rhe_tor
sartors7314973s_artors
saturator946613saturator
scepter1138363scepter
seater64534163s_eater
secretor1045683secretor
sectors93116453s_ectors
seisor63712343s_eisor
seizor15428533s_eizor
selector1048623selector
senator7313073senator
senhor93010813s_enhor
senior63214053s_enior
senor53822803s_e_nor
sensor63813843s_ensor
serer55935513s_er_er
serger73819743s_erger
sermon8413553s_ermon
serow86720443s_er_ow
server94917713s_erver
servitor1145063s_ervitor
servo84516683s_ervo_
servos93812723s_ervos
seton55223543s_e_ton
setter64023723s_etter
settlor7314733settlor
sexto124415453s_exto_
sexton133610793s_exton
sextos134012163s_extos
sheeter103814913sheeter
shelter103214963shelter
sheroot10414373sheroot
shorter103515503shorter
skeeter113410413skeeter
skelter113610003skelter
skirter11338483skirter
smarter94113133smarter
smelter93311913smelter
snorter74412663snorter
sordor7310223s_ordor
sorter64425093s_orter
specter113111733specter
spelter94113703spelter
sporter93616553sporter
spurter94013003spurter
stardom1037763stardom
starer64027363star_er
starker114114693starker
start55642313start__
started84217323started
starters83714783starters
startle72511123startle
startler8248793startler
starts65423123start_s
startsy10536703startsy
startup934963startup
starver104611993starver
starwort1198683starwort
stater64427563st_ater
stators73915583st_ators
stealer72913983stealer
steamer93313093steamer
steeper93812773steeper
steer55423863ste__er
steerer73113633steerer
stelar64013863ste_lar
stellar72610433stellar
stemmer113210183stemmer
stemson945163stemson
steno54716863ste_no_
stenos63915773ste_nos
stent55634513stent__
stents65019453stent_s
stepper113010853stepper
stepson945673stepson
stere55328543ster__e
stereoed937883stereoed
steres63929533ster_es
steric8317063ster_ic
sterile7316603sterile
sterlet71318473sterlet
stern55319123ster__n
sterna63712763ster_na
sternal73411913sternal
sternly1037853sternly
sterns64616763ster_ns
sternson844843sternson
sternum947733sternum
steroid81314873steroid
sterols7313443sterols
stertorous1054983stertorous
stet45947323ste_t__
stets55423913ste_t_s
stetson745783stetson
stetted82610403stetted
stinter73614513stinter
stirrer7338233stirrer
storer64721673stor_er
stouter74012053stouter
stressor875543stressor
stretch1236413stretch
stretta737303stretta
strette7310763strette
stretti747923stretti
stretto737733stretto
strettos847123strettos
strewer104310413strewer
stridor8467393stridor
strook10410303st_rook
strop77422243st_r_op
strow88920573st_r_ow
stroy87720393st_r_oy
stupor836013st_upor
sturt56028963sturt__
sturts63915143sturt_s
stutter72911463stutter
suitor63311053s_uitor
superior10310883superior
svelter10359673svelter
sweater103712723sweater
sweeter103212003sweeter
swelter103711173swelter
swerver1365733swerver
tartar63214753_tartar
tarter64023563_tarter
teeter65420313_teeter
tenor53620253_te_nor
tensor63812673_tensor
tenter64623933_tenter
termer85717253_termer
termors94712773_termors
terrors73112213_terrors
terser67317823_terser
tester64227153_tester
teston6313303_teston
tetter64322453_tetter
torpor839193_torpor
tremor84210403_tremor
turgor736863_turgor
tutor5712493_t_utor
ulterior845453ulterior
vector113212063_vector

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.453394461.4
2DLD Change Limit1340271977.34318252.3
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.87222699.6
 
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.