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 “senor” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
senor5382279(None) 
senhor93010801senhor
senior63214041senior
senora63216151senora
senors63620781senors
sensor63813831sensor
tenor53620251tenor
bevor101510812bevor
censor84011282censor
decor84717572decor
denar65223292denar
donor64418192donor
enol45823822_enol
enorm74415632_enorm
enow77819872_enow
fetor81214532fetor
genoa64315822genoa
genom83716842genom
genro64914032genro
honor85718622honor
keno87926432keno_
kenos95220622kenos
leno47331392leno_
lenos56024862lenos
manor78023932manor
meno66031362meno_
mentor8414362mentor
minor74920062minor
nor38048822__nor
saner54334322saner
sapor75119252sapor
savor85417942savor
sear47353842se_ar
sector83415922sector
seder64826752seder
seer45547042se_er
segno64814742segno_
segnos73610442segnos
sego56525182sego_
segos64919482segos
seiner64622482seiner
seisor63712332seisor
seizor15428522seizor
sen36058522sen__
senary93716072senary
senator7313062senator
send55237292sen_d
sender73824412sender
sends65528242sends
sene46848052sen_e
sengi64016512sengi
senhora10348662senhora
senhors103512122senhors
seniors73413612seniors
senna54617982senna
senoras72714952senoras
senores73218112senores
sensa54117472sensa
sense55526822sense
sensors73514632sensors
sensory10329082sensory
sent46963012sen_t
sente56432872sente
senti56226702senti
sentry92912052sentry
sepoy10314302sepoy
ser36752402se__r
serer55935502serer
serow86720442serow
seton55223542seton
sever85426052sever
sewar85421092sewar
sewer84426212sewer
signor73510352signor
sneer54919952sneer
snob65825592s_nob
snog55623632s_nog
snore55424952s_nore
snort54833752s_nort
snot44745452s_not
snow76324792s_now
sonar56523422sonar
sopor74016492sopor
spinor839942spinor
spoor75016352spoor
steno54716862steno_
stenos63915772stenos
stentor739372stentor
sudor6312622sudor
synod9610282synod
tenon53320512tenon
tenors63217752tenors
tenour62610732tenour
tensor63812672tensor
vendor10359802vendor
venom103914862venom
xenon122612452xenon

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800971.70331591.3
3Display Results97970.0166062.5
 (SQL Overall)178691971.81298615.3
 
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.