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

246 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
decenter11241216(None) 
decanter112510791decanter
decenters122410371decenters
decentre11248551decentre
recenter102715441recenter
cementer1239192cementer
center84421412__center
decanted122310492decanted
decanters12229222decanters
deceiver1436232deceiver
decent94023702decent__
decentered1445322decentered
decentest1249082decentest
decently1448012decently
decentred13236232decentred
decentres12238522decentres
defeater122611662defeater
defender1337292defender
degender1136892degender
demented12311272demented
descanter1246442descanter
descender1346662descender
deserter91211602deserter
detecter11298732detecter
detente83313602detente_
detentes92712862detentes
detester9239682detester
incenter102212092incenter
indecenter1345022indecenter
recanter101913152recanter
reenter73217792re_enter
repenter102813862repenter
absenter1086773absenter
accented13107773accented
accentor12106123accentor
accepter14144933accepter
ancienter1145393ancienter
ascender1136733ascender
assenter867703assenter
begetter11136313begetter
besetter10137973besetter
canter85230113__canter
cemented1338373cemented
cementers1338303cementers
censer84516583__censer
centers94420593__centers
centner946853__centner
centre84316643__centre
concenter13312213concenter
daunter83811753d_aunter
deadener1036743deaden_er
debater104114693de_bater
debenture1243473debenture
deboner103110483debon_er
debunker1543093debunker
decaliter1247983decaliter
decameter14137363decameter
decane93818873decan_e_
decanes103118913decan_es
decant93524223decant__
decants103514443decant_s
decayer13339353dec_ayer
decease1049523decease_
deceased1247713deceased
deceases11410153deceases
deceit93018213deceit__
deceits102810883deceit_s
deceive1337813deceive_
deceived1535893deceived
deceivers1535723deceivers
deceives1437903deceives
decemvir1641963decemvir
decenary1446273decenary
decencies1448943decencies
decency1537453decen_cy
decennary1543463decennary
decennia1144223decennia
decentering1546483decentering
decerned1237263decerned
decider114213183dec_ider
deciliter1247033deciliter
decimeter14147413decimeter
decipher1644423decipher
decker135215993dec__ker
declarer1148063declarer
decliner113710843decliner
decocted1437683decocted
decoder113712293dec_oder
decoyer13348683dec_oyer
decreer10269123dec_reer
decrier102713553dec_rier
deedier93011593de_edier
deemster1175713deemster
deepener1145183deepen_er
deeper93613503de_e_per
defeated132812163defeated
defeaters13289093defeaters
defected15289973defected
defector14277953defector
defence1339893defence_
defenced1537203defenced
defences1439633defences
defended1437223defended
defenders1436363defenders
defense1137503defense_
defensed1336223defensed
defenses1237913defenses
deferrer12135593deferrer
definer114413773defin_er
deflater123211603deflater
defter104215923d__efter
degenders1236083degenders
dejected19307593dejected
dejeuner1682933dejeuner
delete73620703dele_te_
deleted93314903dele_ted
deletes83117933dele_tes
deluster936903deluster
demander12238723demander
dement93825143dement__
dementia1157823dementia
dements103016623dement_s
demerger12127373demerger
demister11310223demister
dempster1355773dempster
denier74420693d__enier
denser74115193d__enser
dented84120513d__ented
depended1337983depended
depicter1356853depicter
depleter11298853depleter
deporter1169393deporter
deranger1037353deranger
deringer1038143deringer
dernier83011943de_rnier
desalter938363desalter
descanted1336673descanted
descanters1345013descanters
descended1446283descended
descenders1445453descenders
descent102616293descent__
descents112511203descent_s
deserted101012203deserted
deserters10129983deserters
deserver12118383deserver
detected12289733detected
detecters12217753detecters
detector11278323detector
detent73624483detent__
detents83615153detent_s
deter65028043d__e_ter
deterger10147593deterger
deterrer9137013deterrer
detested10279623detested
detesters10298303detesters
devested13239133devested
devouter1235513devouter
dewater112912423de_water
dexter143810893d__exter
dicentra1145433dicentra
diester83013683d_iester
dieter73516773d_ie_ter
digester10258423digester
dimeter10411893dime_ter
directer1137583directer
disinter9310673disinter
dissenter1059133dissenter
diverter12238623diverter
docent92918683docent__
docents102810803docent_s
documenter1553283documenter
dopester1137253dopester
duecento1143563duecent_o
duecentos1243153duecentos
dysentery1643043dysentery
emender10649843_emender
enter54726383___enter
epicenter1395503epicenter
erecter93113393_erecter
evener91010623_even_er
fermenter1497543fermenter
fomenter1339263fomenter
incented112412543incented
incenters112510303incenters
indenter92311443indenter
inventer112410843inventer
keener104012833ke_en_er
keester11319913ke_ester
lamenter1038863lamenter
levanter1145303levanter
licencer12146133licencer
licenser10155883licenser
licente91210893licente_
meeter83616503me_e_ter
mesentera1144653mesentera
mesentery1444843mesentery
metacenter1452893metacenter
misenter10310833misenter
orienter838313orienter
precented14310693precented
precentor1348733precentor
presenter11311643presenter
preventer1438593preventer
recanted112513513recanted
recanters112310483recanters
receiver1337413receiver
recensor1045543recensor
recent83630853recent__
recentest11410283recentest
recently1339423recently
receptor1256693receptor
reciter94117263rec_iter
reconfer1337673reconfer
recounter1137943recounter
reenters82915303re_enters
reheater113413033reheater
reinter73116843re_inter
rejecter17258943rejecter
relented92614943relented
reletter81311023reletter
renter64527413__renter
repeater102615443repeater
repented112614983repented
repenters112511553repenters
rerented92516163rerented
resented92716963resented
resetter81511833resetter
revenger1237303revenger
revenuer1136893revenuer
reverter114812873reverter
scanter94215183_scanter
scented102811883_scented
scepter1138353_scepter
seceder10329573sece_der
seconder1137183seconder
secreter1038503secreter
semester1038903semester
serener73415753seren_er
silenter838873silenter
subcenter1347063subcenter
teener64717503te_en_er
teenier72611143te_enier
teeter65420313te_e_ter
tenter64623933__tenter
venter94218723__venter
weenier103210803we_enier

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622467.43619656.0
3Display Results2462460.1102236.4
 (SQL Overall)1786912467.70223200.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.