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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

168 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
tense5522584(None) 
cense75121401cense
dense65923501dense
lense54523431lense
mense75025631mense
sense55526821sense
tease55428711tease
tenge65720431tenge
tens45647411tens_
tensed74817831tensed
tenser64919431tenser
tenses64722551tenses
terse55026821terse
bene66439492ben_e
benes75536232benes
benne76521122benne
bens65945702bens_
cease75227652cease
censed94016322censed
censer84516582censer
censes83721802censes
dene56643412den_e
denes65639722denes
dens55945072dens_
denser74115192denser
ease45042332_ease
else45923082_else
ens37245922_ens_
ensue54013832_ensue
esne47018792_esne
fease84824872fease
fence105319912fence
fens76139762fens_
fesse86116332fesse
flense938902flense
geese64316002geese
gene56237222gen_e
genes65133092genes
genie66124922genie
genre66016802genre
gens55740072gens_
hanse85722792hanse
hence104920042hence
henge94819822henge
hens75642572hens_
intense72511902intense
jesse126012832jesse
kens85435232kens_
kente95821062kente
lease55230262lease
lenes54738522lenes
lens46146492lens_
lensed74015472lensed
lenses64620892lenses
manse75528232manse
mensa75318662mensa
mensae84114042mensae
mensed93916542mensed
menses84222452menses
mensh105413552mensh
mesne75116292mesne
nene45932062nen_e
nenes55329672nenes
pease75231112pease
peise75825772peise
pence94924452pence
penes75839222penes
penne75423852penne
pens65649642pens_
pensee8417312pensee
perse75429522perse
rente54733782rente
reuse56025362reuse
rinse54820972rinse
seise54727852seise
sene46848052sen_e
sensa54117472sensa
sensed73918162sensed
sensei64712592sensei
senses63923942senses
sente56432872sente
spense83912432spense
tans46154822tans_
tansy84514932tansy
tasse54821842tasse
tawse85616502tawse
teas45851492teas_
teased74721152teased
teasel63914982teasel
teaser65421522teaser
teases65426272teases
teds54932572teds_
tee38366872te__e
teens56227482teens_
teensy9478272teensy
tees45353582tees_
tegs56031492tegs_
telae54323292telae
tele45040872te_le
teles54536002teles
tels46841692tels_
ten35856112ten__
tenace82715692tenace
tench105620002tench
tend56433772ten_d
tended83819482tended
tender74121842tender
tends65425582tends
tendu67216002tendu
tenet55542212tenet
tenia55324482tenia
teniae64517352teniae
tenner64117102tenner
tenon53320512tenon
tenor53620252tenor
tenrec837512tenrec
tensely1037362tensely
tensest72713312tensest
tensile72612732tensile
tensive10269912tensive
tensor63812672tensor
tent46159862ten_t
tented74221002tented
tenter64623932tenter
tenth85421832tenth
tentie62521182tentie
tents56434212tents
tenty86121602tenty
tenues63816442tenues
tenure6311612tenure
tepee74724212tepee
terce75721842terce
terne56426152terne
ternes65422902ternes
terns55226872terns_
terser67317822terser
test48651622te_st
tets45847462tets_
tews76431642tews_
thence112010842thence
thens85921832thens_
these86519012these
those85218142those
tine45855132tin_e
tines54848422tines
tinge64626622tinge
tins45251302tins_
tinsel639442tinsel
tone46953742ton_e
tones56048662tones
tonne54921432tonne
tons46553052tons_
torse55833332torse
touse55430672touse
tsetse664692tsetse
tune45635862tun_e
tunes55332192tunes
tuns45138662tuns_
tyne76325052tyn_e
tynes85920302tynes
venae85920982venae
venge95117982venge
venose9310842venose
venue84918212venue
verse84723582verse
wens76337932wens_
yens75832262yens_
yente86220042yente

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 Limit538001681.73630990.8
3Display Results1681680.0463652.2
 (SQL Overall)1786911681.87595301.9
 
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.