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

329 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
censors9361184(None) 
censers94313901censers
censor84011291censor_
sensors73514641sensors
tensors72712371tensors
candors104216762candors
cansos84915382canso_s
cantors94620752cantors
censer84516582censer_
censes83721802cens_es
censored11197952censored
censure92310602censure
censures102211622censures
census84310302cens_us
centers94420602centers
centos85920462cento_s
condors104018572condors
consols92914072consols
consort91319902consort
consorts101512342consorts
cursors93910022cursors
lessors73610522lessors
licensors11104022licensors
mentors9314992mentors
recensors1176132recensors
seisors73212842seisors
senhors103512132senhors
seniors73413622seniors
senors63620792sen_ors
sensor63813842sensor_
sensory10329092sensory
tenors63217752ten_ors
tensor63812672tensor_
vendors113510222vendors
accentors13116053accentors
aeneous739893aeneous
bedsore1057803bedsore
bedsores1157633bedsores
benders104021063benders
benisons1037043benisons
bentos86218303bento_s
benzols1836673benzols
besnows1245153besnows
besoms105712733be_soms
besots86415453be_sots
bettors93312473bettors
bevors111610343be_vors
caesars9410733caesars
cancers114018583cancers
candor94516423candor_
candours11408643candours
caners84629203can_ers
cankers134418753cankers
canners93822663canners
cannons94412883cannons
canoers94318373canoers
canoes84725883can_oes
canons85522063can_ons
canso75019403canso__
canters94827733canters
cantons95221203cantons
cantor85621523cantor_
cantos84826973canto_s
canyons124511593canyons
captors113914983captors
castors94919443castors
causers94014793causers
ceases84427073ceas_es
cedars93312833ce_dars
ceders93817673ce_ders
ceilers93912533ceilers
cellars93713693cellars
cellos84517803cello_s
celoms10412123ce_loms
cenote83715843cen_ote
cenotes92814543cenotes
cense75121403cens__e
censed94016323cens_ed
censing104215263censing
censorial11117503censorial
censoring1238783censoring
censorious1243673censorious
censorship1754693censorship
censual937663censual
censured11248913censured
censurer10228133censurer
censurers11256073censurers
censuses10187543censuses
centals94317053centals
centare93113703centare
centares102913893centares
centas85020703cen_tas
centaurs1035733centaurs
center84421413center_
centners1057243centners
cento76625173cento__
centones10313663centones
centra84113883cen_tra
centre84316643cen_tre
centres93817123centres
cents74730333cen__ts
centums11398783centums
century1237193century
ceorl7410923ce__orl
ceorls848163ce__orls
cernuous1055013cernuous
ceros74726073ce_ro_s
cerous85821203ce_rous
cess65326053ce_s__s
cesses84221363ce_sses
cessions1039853cessions
cestas85018543ce_stas
cestos84718093ce_stos
cestus84412913ce_stus
cesura838763ce_sura
cesuras958693ce_suras
chadors1338753chadors
chansons1337473chansons
chantors133710263chantors
chasers123714923chasers
cinders104617763cinders
cineols9128853cineols
clamors11710093clamors
clangors11417003clangors
cleansers11335073cleansers
closers94415323closers
coenamors1344703coenamors
colessors1145663colessors
colors86622373c_olors
concord12510343concord
concords1358593concords
concours1239473concours
concurs11311473concurs
condoes104319203condoes
condoms124214083condoms
condor94616973condor_
condores113315643condores
condos94322333condo_s
confers124120093confers
conform14310463conform
conforms1538873conforms
congers104223233congers
congoes103617303congoes
congos94219883congo_s
congous103615083congous
conkers133721043conkers
conners94023113conners
consol82614113conso_l
console92715983console
consolers112510923consolers
consoles103216153consoles
consuls92412313consuls
contort91422343contort
contorts101112643contorts
contos84923233conto_s
contours1039653contours
convoys15267023convoys
cors66656443c___ors
creasers103612843creasers
creators102814413creators
creosols1045723creosols
cresols939653cresols
cruors838643c_ruors
cunners93913473cunners
cursers94317163cursers
cursor84110293cursor_
cursory12406393cursory
cussers94213403cussers
cussos84210003cusso_s
debtors1038533debtors
decors94017773de_cors
denars74621433den_ars
deniers84515183deniers
denser74115193denser_
desorb95210203de_sorb
desorbs10437713de_sorbs
devisors12347253devisors
donors75115793don_ors
enamors939123_enamors
encore8314773_encore
encores9315213_encores
enders74324053_enders
endorse879203_endorse
endows104610423_endows
enjoys1644603_enjoys
enols54718403_en_ols
enorm74415643_en_orm
enosis63816423_enosis
enows85115493_en_ows
enrols61213383_enrols
enserf9310763_enserf
enserfs1035483_enserfs
ensoul638253_ensoul
ensouls736033_ensouls
ensues63313813_ensues
ensure63416003_ensure
ensures73315903_ensures
enters64425643_enters
envois988703_envois
envoys1255143_envoys
ephors11311403_ephors
errors63311313_errors
extensors1644083extensors
fencers123810623fencers
fenders113717263fenders
fervors1336233fervors
fetors91014473fe_tors
flensers1135463flensers
genders93616783genders
genitors937423genitors
genoas74013623gen_oas
genoms94412483gen_oms
genros74211333genro_s
gentoos838633gentoos
gessoes838293gessoes
geysers1135703geysers
hansoms12238523hansoms
hectors123513263hectors
honors94816793hon_ors
jetsoms16124723jetsoms
juniors1475783juniors
kelsons1137323kelsons
kendos114510663kendo_s
kenos95220623ken_o_s
kenosis11369003kenosis
leasers74717843leasers
lectors93415773lectors
lenders84419643lenders
lenos56024863len_o_s
lenses64620893lens_es
lentos65317403lento_s
lessons73811023lessons
lessor64010603lessor_
licensers11114583licensers
licensor10113723licensor_
manors84420883man_ors
menders103818803menders
menhirs1235913menhirs
mensas85115863mens_as
menses84222453mens_es
menshes12310453menshes
mentor8414363mentor_
mesons83215843me_sons
meteors94610013meteors
minors85117103min_ors
nelsons738003nelsons
nestors73614973nestors
pengos94612413pengo_s
penners93414183penners
pennons939713pennons
pensees9311203pensees
pensils92811593pensils
pensions10311693pensions
pensters103012123pensters
persons93717013persons
pesos77221623pe_so_s
plessors10278253plessors
precensors1445463precensors
pressors103212693pressors
rancors9811373rancors
ransoms92410163ransoms
reasons72514943reasons
recensor1045543recensor_
rectors93520523rectors
renders83821673renders
renters74224813renters
renvois1036503renvois
resods74116303re_sods
resorb84914353re_sorb
resorbs95010523re_sorbs
resort65728623re_sort
resorts74817193re_sorts
resows93915353re_sows
revisors11379063revisors
rinsers73815743rinsers
sansars73313913sansars
scissors1054353scissors
seasons72614233seasons
sectors93116453sectors
seisers73816393seisers
seisor63712343seisor_
seizors16329013seizors
senators8312953senators
senders83022353senders
senhor93010813senhor_
senhora10348673senhora
senhoras11278283senhoras
senhores112810993senhores
senior63214053senior_
senor53822803sen_or_
senora63216163sen_ora
senoras72714953sen_oras
senores73218113sen_ores
senseis73310643senseis
senses63923943sens_es
sensoria8117533sensoria
sensuous845903sensuous
sponsors1045753sponsors
stentors839743stentors
teasers75317243teasers
telsons739223telsons
tenders83719723tenders
tendons8311473tendons
tenners74014923tenners
tenons62916603ten_ons
tenor53620253ten_or_
tenours72610073tenours
tenser64919433tenser_
tenses64722553tens_es
tensions8310223tensions
tenters73921103tenters
tenuous738483tenuous
termors94712773termors
terrors73112213terrors
tussors7388773tussors
vectors123212593vectors
venders113717003venders
vendor10359803vendor_
veneers103710293veneers
venisons1136133venisons
venoms114211213ven_oms
venous93713193ven_ous
venters103717733venters
versers103813523versers
versos93812803verso_s
visors92912223_visors
weasons102310583weasons
weldors11238003weldors
xenons132710483xen_ons

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340273296.93619323.4
3Display Results3293290.1262611.1
 (SQL Overall)1786913297.45223978.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.