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

192 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
censured1124891(None) 
censored11197951censored
censure92310601censure_
censurer10228131censurer
censures102211621censures
censused11184971censused
ensured83512941_ensured
censed94016322cens__ed
censurers11256072censurers
censuses10187542censuses
centered112513522centered
centred103411682cen_tred
closured11266352closured
coendured1344092coendured
coinsured1245512coinsured
conjured18117902conjured
consumed1337922consumed
endured93611212_endured
ensued73610482_ensu_ed
ensure63416002_ensure_
ensurer73011902_ensurer
ensures73315902_ensures
enured73315332_en_ured
insured83714252_insured
leisured934762leisured
measured1136462measured
reinsured1036982reinsured
tenured838362ten_ured
tonsured976382tonsured
uncensured1344002uncensured
unensured1044942unensured
ventured1238272ventured
assured858373_assured
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capsuled1334533capsuled
captured1336573captured
ceased94920783ceas__ed
ceinture1036313ceinture_
ceintures1136733ceintures
cellared11398793cellared
cense75121403cens__e_
censer84516583cens__er
censers94313903censer_s
censes83721803cens__es
censor84011293censor__
censors93611843censor_s
censual937663censu_al
censuring1237603censuring
census84310303censu__s
centare93113703centare_
centares102913893centares
centaurea1143503centaurea
centre84316643cen_tre_
centres93817123cen_tres
centupled14143163centupled
centuries11311333centuries
century1237193centur_y
cered85227443ce___red
cessed94615613ce_s_sed
cesura838763ce_sur_a
cesurae937703ce_surae
cesuras958693ce_suras
cinctured1444273cinctured
cindered1239793cindered
closure9278483closure_
closures10228953closures
clotured11246163clotured
cloured103111543c_loured
coendure1145463coendure_
coendures1245213coendures
coenure968153coen_ure_
coenures1048683coen_ures
coinsure1046933coinsure_
coinsurer1144773coinsurer
coinsures1136723coinsures
coloured1148313coloured
concurred1445673concurred
conduced14136963conduced
confused1437033confused
confuted1437683confuted
conjure16109073conjure_
conjurer17117683conjurer
conjures17119913conjures
conquered2145463conquered
conserved1538853conserved
consoled112911453consoled
consorted1239773consorted
conspired1445663conspired
construed1247313construed
consulted1277923consulted
consume11510133consume_
consumer1238503consumer
consumes12310413consumes
contoured1237303contoured
contused1138443contused
cultured1137233cultured
cured85932133c___ured
cynosure1343553cynosure_
cynosures1443873cynosures
denatured1146033denatured
denture8311893denture_
dentures9312453dentures
denuded10167663den_uded
desired9311983de_sired
detoured1036513detoured
devoured1335723devoured
encored10412103_encored
endued83910373_endu_ed
endure74014143_endure_
endurer83210363_endurer
endures83314603_endures
enquired18255793_enquired
enserfed1245193_enserfed
ensiled82611433_ensiled
enskied1234653_enskied
enskyed1532503_enskyed
ensnared965293_ensnared
ensouled935833_ensouled
ensue54013833_ensu_e_
ensues63313813_ensu_es
ensurers8279373_ensurers
entered82718883_entered
enure53520223_en_ure_
enures63919713_en_ures
featured1237683featured
fendered13258673fendered
fissured1235183fissured
gendered11258873gendered
gestured1036993gestured
honoured1236313honoured
injured15339063_injured
insure63416603_insure_
insureds9277613_insureds
insurer73312803_insurer
insures73117263_insures
inured73114813_in_ured
lectured11127233lectured
leisure736693leisure_
leisures836683leisures
lensed74015473lens__ed
licensure1143043licensure_
licensures1243053licensures
manured1039473man_ured
measure939033measure_
measurer1035953measurer
measures1038913measures
mensed93916543mens__ed
mensural1046233mensural
mentored1138003mentored
perdured12287403perdured
perjured18286273perjured
pleasured1244193pleasured
pressured1237333pressured
reassured1046103reassured
recensored1344253recensored
reinjured1744533reinjured
reinsure837913reinsure_
reinsurer945603reinsurer
reinsures937963reinsures
renatured1047293renatured
rendered102512263rendered
repoured1139563repoured
resumed10310623re_sumed
resurged1038623re_surged
secured1059723se_cured
seisure738193seisure_
seisures838273seisures
sensated938193sensated
sensed73918163sens__ed
tendered102510603tendered
tensed74817833tens__ed
tentered96412103tentered
tenure6311613ten_ure_
tenures7412013ten_ures
textured1695483textured
tonsure758783tonsure_
tonsures869133tonsures
treasured1044983treasured
uncensored1354253uncensored
uncured10513233_uncured
uninsured1044873uninsured
unsoured9310063_unsoured
unsure62815413_unsure_
velured1136683ve_lured
veneered1235983veneered
venture10311173venture_
venturer1137243venturer
ventures11311493ventures
verdured13255763verdured
vestured1237463vestured

Search took 9 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 Filter1786911461620.403443402.0
2DLD Change Limit1461621927.75318852.3
3Display Results1921920.0762526.3
 (SQL Overall)1786911928.23221706.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.