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

166 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
sense5552682(None) 
cense75121401cense
dense65923501dense
lense54523431lense
mense75025631mense
seise54727851seise
sene46848051sen_e
sensa54117471sensa
sensed73918161sensed
sensei64712591sensei
senses63923941senses
sente56432871sente
spense83912431spense
tense55225841tense
bene66439492ben_e
benes75536232benes
benne76521122benne
bens65945702bens_
cease75227652cease
censed94016322censed
censer84516582censer
censes83721802censes
dene56643412den_e
denes65639722denes
dens55945072dens_
denser74115192denser
ease45042332_ease
else45923082_else
ens37245922_ens_
ensue54013832_ensue
esne47018792esn_e
esnes54817362esnes
fease84824872fease
fence105319912fence
fens76139762fens_
fesse86116332fesse
flense938902flense
geese64316002geese
gene56237222gen_e
genes65133092genes
genie66124922genie
genre66016802genre
gens55740072gens_
hanse85722792hanse
hence104920042hence
henge94819822henge
hens75642572hens_
jesse126012832jesse
kens85435232kens_
kente95821062kente
lease55230262lease
lenes54738522lenes
lens46146492lens_
lensed74015472lensed
lenses64620892lenses
manse75528222manse
mensa75318662mensa
mensae84114042mensae
mensed93916542mensed
menses84222452menses
mensh105413552mensh
mesne75116292mesne
nene45932062nen_e
nenes55329672nenes
pease75231112pease
peise75825772peise
pence94924452pence
penes75839222penes
penne75423852penne
pens65649642pens_
pensee8417312pensee
perse75429522perse
rente54733782rente
reuse56025362reuse
rinse54820972rinse
sane45954332san_e
sanes55649072sanes
sans45153352sans_
sansei63411902sansei
scene77220572scen_e
scenes84520352scenes
seance83716682seance
seas45755272seas_
secs65033892secs_
sedge75019952sedge
see35772262se__e
sees45361052sees_
segs54933882segs_
segue6314412segue
seine55732872seine
seines65029902seines
seis45542392seis_
seised74218122seised
seiser65318342seiser
seises64026712seises
seism75019022seism
seize143819502seize
selle54428312selle
sels46345982sels_
seme65836652se_me
semes75731582semes
sen36058522sen__
senate63725142senate
send55237292sen_d
sended85121232sended
sender73824412sender
sends65528242sends
sengi64016512sengi
senile63420212senile
senna54617982senna
sennet64224142sennet
senor53822792senor
sensate7311882sensate
senseis73310642senseis
sensor63813832sensor
sensum849352sensum
sent46963012sen_t
senti56226692senti
sepses84515882sepses
sere46153472se_re
seres55448892seres
serge64727462serge
sers45746652sers_
serve85425962serve
setae56026222setae
setose65114772setose
sets45549502sets_
sews75836022sews_
sexes126126222sexes
since75024172since
sine46560622sin_e
sines55954822sines
singe65731132singe
sins46755272sins_
skene96118122sken_e
skenes104616632skenes
snye77115492s_nye
sonde64622832sonde
sone46649982son_e
sones55444142sones
sons46049552sons_
sonsie6614852sonsie
sonsy86416372sonsy
souse56530772souse
speise84614252speise
spence103813792spence
spenses92913572spenses
suns45841902suns_
sunset63723632sunset
syne75725762syn_e
tease55428712tease
tenge65720432tenge
tens45647412tens_
tensed74817832tensed
tenser64919432tenser
tenses64722552tenses
terse55026822terse
tsetse664692tsetse
venae85920982venae
venge95117982venge
venose9310842venose
venue84918212venue
verse84723582verse
wens76337932wens_
yens75832262yens_
yente86220042yente

Search took 4 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.186960704.3
2DLD Change Limit538001663.43615657.7
3Display Results1661660.0463608.7
 (SQL Overall)1786911663.66848716.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.