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

187 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
decenters12241037(None) 
decanters12229221decanters
decenter112412161decenter_
decentres12238521decentres
cementers1338312cementers
centers94420602__centers
decanter112510792decanter_
deceivers1535722deceivers
decentered1445322decentered
decentest1249082decentest
decentre11248552decent_re
decentred13236232decentred
defeaters13289102defeaters
defenders1436362defenders
degenders1236082degenders
descanters1345012descanters
descenders1445452descenders
deserters10129982deserters
detecters12217752detecters
detentes92712872detente_s
detesters10298302detesters
incenters112510302incenters
recanters112310482recanters
recenter102715442recenter_
reenters82915302re_enters
repenters112511552repenters
absenters1156173absenters
accentors13116053accentors
accepters15114603accepters
ascenders1235683ascenders
assenters966993assenters
begetters12135043begetters
besetters11136633besetters
canters94827733__canters
cementer1239193cementer_
censers94313903__censers
center84421413__center_
centners1057243__centners
centres93817123__centres
concenters14410583concenters
daunters9329853d_aunters
deadeners1146283deaden_ers
debaters113511923de_baters
debenture1243473debenture
debentures1343533debentures
deboners11268113debon_ers
debunkers1642703debunkers
decaliters1345213decaliters
decameters15156593decameters
decanes103118913decan_e_s
decanted122310493decante_d
decants103514443decant__s
decayers14307963dec_ayers
deceases11410153decease_s
deceits102810883deceit__s
deceiver1436233deceiver_
deceives1437903deceive_s
decemvirs1741993decemvirs
decenary1446273decen_ary
decencies1448943decencies
decennary1543463decennary
decent94023703decent___
decentering1546483decentering
decently1448013decent_ly
deciders123510753dec_iders
deciliters1345173deciliters
decimeters15156683decimeters
deciphers1744393deciphers
deckers144413833dec__kers
declarers1236423declarers
decliners12358613decliners
decoders122810413dec_oders
decoyers14287713dec_oyers
decreers11277623dec_reers
decriers11299733dec_riers
deemsters1285023deemsters
deepeners1244523deepen_ers
defeater122611663defeater_
defectors15237883defectors
defences1439633defence_s
defender1337293defender_
defenses1237913defense_s
deferrers13115153deferrers
definers124211193defin_ers
deflaters13298703deflaters
degender1136893degender_
dejeuners1742443dejeuners
deletes83117933dele_te_s
delusters1035983delusters
demanders13247573demanders
demented12311273demente_d
dementias1257403dementias
dements103016623dement__s
demergers13146403demergers
demisters1249203demisters
dempsters1435273dempsters
deniers84515183d__eniers
depicters1435823depicters
depleters12327543depleters
deporters1277793deporters
derangers1136703derangers
deringers1137183deringers
desalters1037673desalters
descanter1246443descanter_
descender1346663descender_
descents112511203descent__s
deserter91211603deserter_
deservers13107293deservers
detecter11298733detecter_
detectors12278303detectors
detente83313603detente__
detents83615153detent__s
detergers11147183detergers
deterrers10116593deterrers
deters74724683d__e_ters
detester9239683detester_
dewaters122910723de_waters
dicentra1145433dicent_ra
dicentras1245473dicentras
diesters92513603d_iesters
dieters83216433d_ie_ters
digesters11257883digesters
dimeters11411093dime_ters
disinters1039713disinters
dissenters1197723dissenters
diverters13227873diverters
docents102810803docent__s
documenters1652813documenters
dopesters1237283dopesters
duecentos1243153duecent_os
dysentery1643043dysentery
emenders11319033_emenders
enters64425643___enters
epicenters14114463epicenters
erecters102611613_erecters
eveners10109503_even_ers
fermenters15116533fermenters
fomenters1437853fomenters
incenter102212093incenter_
indecenter1345023indecenter_
indenters102710033indenters
inventers12269533inventers
keeners113610783ke_en_ers
keesters12319593ke_esters
lamenters1137683lamenters
levanters1254993levanters
licencers13134643licencers
licensers11114583licensers
meeters94714543me_e_ters
mesentera1144653mesentera
mesentery1444843mesentery
metacenters1552483metacenters
misenters1139533misenters
orienters937613orienters
precentors1488343precentors
presenters1239863presenters
preventers1547393preventers
recanter101913153recanter_
receivers1436363receivers
recensors1176133recensors
recentest11410283recentest
recentness1245463recentness
receptors1356923receptors
reciters102613113rec_iters
reconfers1437213reconfers
recounters1246213recounters
reenter73217793re_enter_
reheaters122010273reheaters
reinters82614773re_inters
rejecters18257543rejecters
reletters9138783reletters
renters74224813__renters
repeaters112811993repeaters
repenter102813863repenter_
resetters9129463resetters
revengers1336413revengers
revenuers1235983revenuers
reverters122710433reverters
scepters1237793_scepters
seceders11277963sece_ders
seconders1236953seconders
semesters1139123semesters
subcenters1446163subcenters
teeners74415453te_en_ers
teeters74018303te_e_ters
tenters73921103__tenters
venters103717733__venters

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411876.45323034.4
3Display Results1871870.0802337.5
 (SQL Overall)1786911876.95325699.8
 
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.