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

477 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
centred10341168(None) 
centered112513521centered
centre84316641centre_
centres93817121centres
canted94825782cant_ed
cantered113415982cantered
censed94016322cen_sed
censored11197952censored
censured11248912censured
centare93113702centare_
centares102913892centares
center84421412cent_er
centers94420592centers
centner946852centner
centra84113882centr_a
central93114472central
centric11312392centric
centroid1159302centroid
centrum1168602centrum
cered85227442ce__red
decentred13236232decentred
dented84120512dent_ed
entered82718882_entered
entree61817882_entree
enured73315332_enured
gentled9389092gentled
hented104218752hent_ed
mentored1138002mentored
metred95315142me_tred
rented74426592rent_ed
scented102811882scent_ed
sceptred1343652sceptred
tented74221002tent_ed
tentered96412102tentered
tenured838362tenured
vented104617922vent_ed
ventured1238272ventured
accented13107773accent_ed
acentric1247513acentric
agented939423agent_ed
aneared8512743aneared
anted66328243_ant_ed
anteed75616113_anteed
antired82316193_antired
antre55224523_antre_
antres65021003_antres
bantered113313633bantered
beetled1038213beetled
belted94020633belt_ed
bemired123410633bemired
benamed122911093benamed
benched154713943benched
bended105521233ben_ded
berthed13259123berthed
bested94922753best_ed
bestrew1248003bestrew
bestrid1039973bestrid
betted94721163be_tted
bettered113011833bettered
bewared13310113bewared
bistred103311853bistred
bunted95219183bunt_ed
canaled103615553canaled
canard9314763canar_d
cancered132411553cancered
candied113816023candied
candled113815733candled
caned85838093can__ed
cankered153010223cankered
canned95022063can_ned
canoed94618953can_oed
canteen9411083canteen
canter85230113cant_er
canters94827723canters
cantle84522153cantle_
cantles94721413cantles
cantoned111411523cantoned
cantrap113310273cantrap
cantrip112910033cantrip
capered123014043capered
captured1336563captured
cared86050093c__ared
carted98631443cart_ed
castled104311513castled
catered103117763catered
catted95422473c_atted
ceased94920783ce_ased
ceded96118553ce__ded
ceiled94114953ce_iled
ceinture1036313ceinture_
ceintures1136733ceintures
cellared11398793cellared
celled94420323ce_lled
cemented1338373cement_ed
cenote83715843cenote_
cenotes92814543cenotes
cense75121403cen_se_
censer84516583cen_ser
censers94313903censers
censes83721803cen_ses
censure92310603censure_
censurer10228133censurer
censures102211623censures
censused11184973censused
cent67451013cent___
centai84814783cent_ai
cental84420963cent_al
centals94317053centals
centas85020703cent_as
centaur935783centaur
centaurea1143503centaurea
centavo1245103centavo
centeses1079443centeses
centiare1067203centiare_
centiares1167653centiares
centile94217183centile
centiles103615813centiles
centime114513033centime
centimes124012613centimes
centimo11609543centimo
centipede1442933centipede
centners1057243centners
cento76625173cent__o
centones10313663centones
centos85920463cent_os
centraler1146683centraler
centrals102712033centrals
centring112112953centring
centrism1249643centrism
centrist10314863centrist
centroids1247033centroids
centrums1236913centrums
cents74730333cent__s
centu76119413cent__u
centum104012363cent_um
centums11398783centums
centupled14143163centupled
centuries11311333centuries
century1237193century
cerated103922473cerated
cere66741473ce__re_
ceres75540013ce__res
certes84623083cert_es
cessed94615613ce_ssed
cestode1037963cestode
cestoid104011673cestoid
cete64934783ce_t_e_
cetes75731103ce_t_es
chaired134211243chaired
chanted134015953chant_ed
chared125423693c_hared
charred134614483charred
charted135116853charted
chatted133411893chatted
cheated134416343cheat_ed
cheered133713293cheered
chested133811673chest_ed
chirred133612123chirred
choired13349343choired
chored125321883c_hored
chuntered1536653chuntered
churred13409173churred
chuted124611843chut_ed
chytrid1645713chytrid
cinched153910863cinched
cinctured1444273cinctured
cindered1239793cindered
cisted95217523cist_ed
cited84421953c_it_ed
citied94014143c_itied
cleared103612463cleared
cleated103417843cleat_ed
clefted13326753cleft_ed
clenched16257763clenched
clothed134010283clothed
clotted104011823clotted
clotured11246163clotured
cloured103111543cloured
coated94927033coat_ed
coendured1344083coendured
coenure968143coenure_
coenures1048673coenures
cohered133514693cohered
colored10313473colored
coned86040053con__ed
congaed11399743congaed
congeed113212313congeed
conjured18117893conjured
conked135019113con_ked
conned95119703con_ned
construed1247303construed
conte76633203cont_e_
contend103511893contend
contes84432913cont_es
contorted1239473contorted
contoured1237293contoured
contra83314693contr_a
contras93015603contras
contrived1547993contrived
control9310673control
contused1138443contused
cored85044223c__ored
cornered11311133cornered
costed95623113cost_ed
costrel9310363costrel
coted85033853c_ot_ed
cottered112511733cottered
counted103815803count_ed
countered12312993countered
courted103514913courted
covered133315293covered
cowered133214643cowered
crated94827773crat_ed
cratered1149673cratered
created104323443creat_ed
cred76530883c___red
crenated113013913crenated
creneled11326893creneled
crested103416533crest_ed
cultured1137233cultured
cured85932133c__ured
curred94319263c_urred
cuttled10319933cuttled
deaired9411533deaired
decentered1445323decentered
decentre11248553decentre_
decentres12238523decentres
denatured1146023denatured
denied84318633den_ied
denimed1159233denimed
denned84215633den_ned
denoted93512763denoted
dentated10411703dentated
dentiled1039743dentiled
dentoid9310663dentoid
denture8311893denture_
dentures9312453dentures
denuded10167663denuded
desired9311983desired
dinted84419843dint_ed
dunted84718503dunt_ed
eared65139503_e_ared
encored10412103_encored
ended74421263_en_ded
endued83910373_endued
endured93611213_endured
ensued73610483_ensued
ensured83512943_ensured
enter54726383_ent_er
entera64216833_entera
enterer72015633_enterer
enters64425643_enters
enticed101411193_enticed
entire61617703_entire_
entires71517783_entires
entrap8710563_entrap
entreat7315263_entreat
entrees71813773_entrees
entries71523163_entries
entry82414263_entr_y
enure53520223_enure_
enures63919713_enures
envied1038833_envied
erred65915673_e_rred
feared106320433fe_ared
featured1237683featured
feinted11379623feint_ed
felted103714653felt_ed
fenced124412713fen_ced
fended114216913fen_ded
fendered13258673fendered
festered122512103festered
feted94420933fe_t_ed
fetted104817893fe_tted
fettered12259493fettered
fettled11378933fettled
fevered14339723fevered
geared85317743ge_ared
gendered11258873gendered
genre66016803gen_re_
genres75515623gen_res
genteel836753genteel
gentes75324163gent_es
gentle74014513gentle_
gentler8378953gentler
gentles83714343gentles
gentries91315263gentries
gentry103410443gentr_y
gestured1036993gestured
gettered10258613gettered
hanted104124313hant_ed
hatred104814333_hatred
hearted113314023hearted
heated104525593heat_ed
hectored1436873hectored
hefted134911423heft_ed
heired103813043he_ired
hennaed1135103hennaed
hinted104318323hint_ed
honored11310123honored
hundred1237143hundred
hunted104417013hunt_ed
ignored9226443ignored
inbred93010393_inbred
incented112412543incent_ed
inured73114813_inured
jeered143912793je_ered
jested144416503jest_ed
jetted143915083je_tted
jettied15366973jettied
kenned114411263ken_ned
kente95821063kent_e_
kentes105118643kent_es
kestrel1137113kestrel
kindred13316953kindred
lectured11127223lectured
leered73816223le_ered
lenited8812433lenited
lensed74015473len_sed
lenten6312883lent_en
lentoid8310683lentoid
letted74118543le_tted
lettered92910783lettered
levered114212303levered
linted74021823lint_ed
lunted74517523lunt_ed
lustred8359053lustred
mantled104113393mantled
manured1039473manured
meated94222403meat_ed
melted94219063melt_ed
menaced122710093menaced
mended104418683men_ded
mensed93916543men_sed
mentee84121293ment_ee
mentees93214503mentees
meted85424433me_t_ed
metered103514013metered
metre74821303me_tre_
metres85121563me_tres
mettled103510543mettled
minored10310103minored
minted94220583mint_ed
mitred94414343_mitred
neared75119803ne_ared
nested74720063nest_ed
nestled8349903nestled
netted74118713ne_tted
nettled8339943nettled
neutered937423neutered
panted95024823pant_ed
peered93819483pe_ered
pelted94617753pelt_ed
peltered112510443peltered
pended103819013pen_ded
penned94217613pen_ned
pentad9313763pent_ad
pentode1039893pentode
pestered112814953pestered
pestled102711433pestled
petered103314963petered
petrel83111533pe_trel
petted94121523pe_tted
pettled103611503pettled
peytrel1264253peytrel
punted94618713punt_ed
ranted74324703rant_ed
reared75930013re_ared
rebored105015883rebored
rebred95816353re_bred
reentered1038573reentered
refired115116993refired
rehired115013153rehired
renamed103114523renamed
renatured1047283renatured
rended84524103ren_ded
rendered102512263rendered
reneged92010763reneged
renewed11309993renewed
rente54733783rent_e_
renter64527413rent_er
renters74224813renters
rentes65431193rent_es
rentier73618223rentier
rested74430783rest_ed
restored96417193restored
retied75924983re_tied
retired84620143retired
retread849003re_tread
retried84419153re_tried
retted74826313re_tted
revered112819333revered
rewired115413283rewired
scanted104114393scant_ed
scended11329873scen_ded
sceptered1444723sceptered
sceptre1135043sceptre_
sceptres1244993sceptres
seared75232843se_ared
seated75131053seat_ed
sectored1138063sectored
secured1059723secured
seethed113410193seethed
sended85121233sen_ded
senores73218113senores
sensed73918163sen_sed
sente56432873sent_e_
sentries81318053sentries
sentry92912053sentr_y
sered65737293se__red
settled83210873settled
severed113513863severed
sewered112911243sewered
sintered92213903sintered
snared74824553_snared
sneered83113973sneered
snored74819543_snored
teared75722153te_ared
teated74924023teat_ed
teetered9258303teetered
teethed11318623teethed
tended83819483ten_ded
tendered102510603tendered
tenoned839363tenoned
tenrec837513ten_rec
tensed74817833ten_sed
tenter64623933tent_er
tenters73921103tenters
tentie62521183tentie_
tentier73815923tentier
tenure6311613tenure_
tenures7412013tenures
tested74421523test_ed
tetrad73612053te_trad
textured1695483textured
tinted74419533tint_ed
unbred92613303_unbred
unentered1037573unentered
untied73720813_untied
untired82316383_untired
untread857413_untread
untried82615853_untried
untrod769853_untrod
vectored1435623vectored
veered103612743ve_ered
velured1136683velured
vended114416353ven_ded
veneered1235983veneered
venged114011983ven_ged
venire93513693venire_
venires103012453venires
venomed1336653venomed
venter94218723vent_er
venters103717723venters
ventral103612173ventral
venture10311173venture_
venturer1137243venturer
ventures11311483ventures
vested104217353vest_ed
vestured1237463vestured
vetoed10359823ve_toed
vetted104316323ve_tted
wanted104319723want_ed
weeted103913793weet_ed
welted103715823welt_ed
weltered12238433weltered
wenched163910913wenched
wended113616153wen_ded
westered122511863westered
wetted103717023we_tted
wintered122111573wintered
wintled11339843wintled
wonted103213283wont_ed
yenned10409383yen_ned
yente86220043yent_e_
yentes95517603yent_es
zested164214043zest_ed

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.1561145455.1
2DLD Change Limit1340274777.50017870.3
3Display Results4774770.1702805.9
 (SQL Overall)1786914777.82622833.0
 
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.