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

150 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
cense7512140(None) 
cease75227651cease
censed94016321censed
censer84516581censer
censes83721801censes
dense65923501dense
lense54523431lense
mense75025631mense
sense55526821sense
tense55225841tense
bene66439492ben_e
benes75536232benes
benne76521122benne
bens65945702bens_
cane66653122can_e
canes75350372canes
canoe75627252canoe
cans65050852cans_
canso75019402canso
canst74932212canst
carse74934332carse
case65848082c_ase
cause75225352cause
ceased94920782ceased
ceases84427072ceases
cede74928782ce_de
cedes84927332cedes
cee55952702ce__e
cees65941592cees_
cels65534972cels_
cenote83715842cenote
censers94313902censers
censor84011292censor
censure92310602censure
census84310302census
cent67451012cen_t
center84421412center
cento76625172cento
centre84316642centre
cents74730332cents
centu76119412centu
cepe84926652ce_pe
cepes94424462cepes
ceps86125952ceps_
cere66741472ce_re
ceres75540012ceres
cerise84822042cerise
ceruse83914522ceruse
cess65326052ce_ss
cessed94615612cessed
cesses84221362cesses
cete64934782ce_te
cetes75731102cetes
chase105127122chase
cheese113812762cheese
chose105925402chose
cine66242952cin_e
cines75239682cines
cleanse9358722cleanse
close76425222close
cone67256962con_e
cones76457422cones
conge85227592conge
cons66057692cons_
conte76633202conte
copse95623932copse
corse75036182corse
crease85519572crease
creese84014332creese
cruse75726102cruse
curse75829142curse
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
hence104920052hence
henge94819832henge
hens75642572hens_
incense92410302incense
jesse126012832jesse
kens85435242kens_
kente95821072kente
lease55230262lease
lenes54738522lenes
lens46146492lens_
lensed74015472lensed
lenses64620892lenses
license9148422license
manse75528232manse
mensa75318672mensa
mensae84114052mensae
mensed93916542mensed
menses84222452menses
mensh105413562mensh
mesne75116292mesne
nene45932062nen_e
nenes55329672nenes
pease75231112pease
peise75825772peise
pence94924452pence
penes75839222penes
penne75423852penne
pens65649642pens_
pensee8417312pensee
perse75429522perse
rente54733782rente
reuse56025362reuse
rinse54820972rinse
scene77220572scen_e
scenes84520352scenes
seise54727852seise
sene46848052sen_e
sensa54117472sensa
sensed73918162sensed
sensei64712592sensei
senses63923942senses
sente56432882sente
spense83912432spense
tease55428712tease
tenge65720452tenge
tens45647412tens_
tensed74817832tensed
tenser64919432tenser
tenses64722552tenses
terse55026822terse
venae85920982venae
venge95117992venge
venose9310842venose
venue84918212venue
verse84723582verse
wens76337932wens_
yens75832262yens_
yente86220042yente

Search took 5 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.626285448.9
2DLD Change Limit538001503.50015371.4
3Display Results1501500.0761973.7
 (SQL Overall)1786911504.20242525.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.