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

167 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
censored1119795(None) 
censured11248911censured
censed94016322cens__ed
censor84011282censor__
censors93611832censor_s
censure92310602censure_
censurer10228132censurer
censures102211622censures
censused11184972censused
centered112513522centered
centred103411682cen_tred
consoled112911442consoled
consorted1239772consorted
encored10412102_encored
ensured83512942_ensured
mentored1138002mentored
recensored1344252recensored
uncensored1354252uncensored
bedsore1057803bedsore_
bedsores1157633bedsores
besnowed14124403besnowed
cancered132411553cancered
cankered153010223cankered
cannoned11118133cannoned
canoed94618953can_o_ed
cantered113415983cantered
cantoned111411523cantoned
ceased94920783ceas__ed
cellared11398793cellared
cenote83715843cen_ote_
cenotes92814543cen_otes
cense75121403cens__e_
censer84516583cens__er
censers94313903censer_s
censes83721803cens__es
censorial11117493censorial
censoring1238783censoring
censurers11256073censurers
censuses10187543censuses
centare93113703centare_
centares102913893centares
centones10313663centones
centre84316643cen_tre_
centres93817123cen_tres
centroid1159303centroid
cered85227443ce___red
cessed94615613ce_s_sed
chored125321883c__hored
cindered1239793cindered
clamored1336943clamored
clangored1343653clangored
closured11266353closured
coenamored1562633coenamored
coendured1344083coendured
coinsured1245503coinsured
colored10313473c_olored
concord12510343concor_d
condoled123110713condoled
condoned122612023condoned
condores113315633condores
conformed1767463conformed
conjured18117893conjured
connoted1138863connoted
conserved1538843conserved
console92715983console_
consoler102812613consoler
consoles103216153consoles
consort91319903consor_t
consorts101512333consorts
conspired1445663conspired
construed1247303construed
consumed1337923consumed
contorted1239473contorted
contoured1237293contoured
convoked18236163convoked
convoyed17225553convoyed
cored85044223c___ored
creosoted1244043creosoted
denoted93512763den_oted
deplored1237223deplored
desired9311983de_sired
desorbed1236433de_sorbed
enamored1147033_enamored
encoded1139033_encoded
encore8314773_encore_
encores9315213_encores
endorsed1057193_endorsed
endowed1248173_endowed
endured93611213_endured
enforced14216743_enforced
engorged1134553_engorged
enjoyed1834523_enjoyed
enrobed10279253_enrobed
enserfed1245193_enserfed
ensiled82611433_ensiled
enskied1234653_enskied
enskyed1532503_enskyed
ensnared965293_ensnared
ensorcel1054693_ensorcel
ensouled935833_ensouled
ensued73610483_ens_ued
ensure63416003_ensure_
ensurer73011903_ensurer
ensures73315903_ensures
entered82718883_entered
enured73315333_en_ured
fendered13258673fendered
gendered11258873gendered
gessoed935743gesso_ed
hectored1436873hectored
honored11310123hon_ored
ignored9226443ign_ored
insured83714253_insured
leisured934763leisured
lensed74015473lens__ed
lessoned945393lessoned
measured1136463measured
mensed93916543mens__ed
minored10310103min_ored
pennoned1136313pennoned
pensioned1246653pensioned
precensored1653143precensored
rancored1137223rancored
ransomed1146933ransomed
reasoned9410733reasoned
rebored105015883re_bored
reinsured1036983reinsured
rendered102512263rendered
rescored114513103rescored
resoled84119283re_soled
resorbed1138523re_sorbed
resorted9313493re_sorted
resowed113712253re_sowed
restored96417193restored
scissored1243033scissored
seasoned948113seasoned
sectored1138063sectored
senhores112810993senhores
senores73218113sen_ores
sensated938183sensated
sensed73918163sens__ed
sensor63813833sensor__
sensoria8117533sensoria
sensors73514623sensor_s
sensory10329083sensor_y
snored74819543_sn_ored
sored66141783___sored
sponsored1243213sponsored
tendered102510603tendered
tenoned839363ten_oned
tensed74817833tens__ed
tensioned1045613tensioned
tensor63812673tensor__
tensors72712373tensor_s
tentered96412103tentered
tenured838363ten_ured
tonsured976383tonsured
uncensured1344003uncensured
unensured1044933unensured
unsorted9312513_unsorted
unsoured9310053_unsoured
unsowed112511053_unsowed
vectored1435623vectored
veneered1235983veneered
venomed1336653ven_omed
ventured1238273ventured
visored1138143_visored

Search took 10 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.1561145455.1
2DLD Change Limit1461621679.15615963.5
3Display Results1671670.0931795.7
 (SQL Overall)1786911679.40518999.6
 
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.