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

235 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
detentes9271286(None) 
detente83313601detente_
detents83615151detent_s
decenter112412162decenter
decenters122410372decenters
decentest1249082decentest
decentres12238522decentres
defences1439632defences
defenses1237912defenses
deletes83117932dele_tes
demented12311272demented
dements103016622dement_s
detected12289732detected
detecter11298732detecter
detecters12217752detecters
detects104011092detect_s
detent73624482detent__
detentist1049322detentist
deterges101510082deterges
detested10279622detested
detester9239682detester
detesters10298302detesters
detests83711742detest_s
detinues9569822detinues
detonates10310422detonates
ententes8312762ententes
ketenes114813502keten_es
retenes76324622reten_es
betonies10413063betonies
butenes9313033buten_es
catenates11311803catenates
celestes10310013celestes
cemented1338373cemented
cementer1239193cementer
cementers1338303cementers
cements112714223cement_s
cetanes9315133cetan_es
deaerates10313623deaerates
dealates92716683dealates
debates103718523de_bates
debentures1343533debentures
debones103315113debon_es
debutantes1342613debutantes
decanes103118913decan_es
decanted122310493decanted
decanter112510793decanter
decanters12229223decanters
decants103514443decant_s
deceases11410153deceases
deceits102810883deceit_s
deceives1437903deceives
decencies1448943decencies
decent94023703decent__
decently1448013decently
decentre11248553decentre
decentred13236233decentred
deets65330243de_e_t_s
defeated132812163defeated
defeater122611663defeater
defeaters13289093defeaters
defeats113511233defeat_s
defecates1538583defecates
defected15289973defected
defects134511523defect_s
defence1339893defence_
defenced1537203defenced
defended1437223defended
defender1337293defender
defenders1436363defenders
defends12358773defen_ds
defense1137503defense_
defensed1336223defensed
defines114118683defin_es
deflates123013943deflates
degender1136893degender
degenders1236083degenders
dejected19307593dejected
dejects17389223deject_s
delates83526283de_lates
deleaves1248063deleaves
delegates1139833delegates
delete73620703dele_te_
deleted93314903dele_ted
dement93825143dement__
dementia1157823dementia
dementias1257403dementias
demerges12129503demerges
demesnes1137083demesnes
demotes104717673de_motes
denes65639723d__en_es
denies74729643d__enies
denotes83817003de_notes
dented84120513d__ented
dentines93418393dentin_es
dents65031803d__ent_s
depended1337983depended
depends11348993depen_ds
depletes112810633depletes
depones103717093depon_es
deputes104911783de_putes
deranges1039973deranges
derates84028883de_rates
descents112511203descent_s
deserted101012203deserted
deserter91211603deserter
deserters10129983deserters
deserts82513053desert_s
deserves12109893deserves
desexes1537833dese_xes
despites11410313despites
destines93619663destin_es
destinies10410843destinies
detaches1439653detaches
detainees10267153detainees
detect94217403detect__
detectives1645783detectives
detector11278323detector
detectors12278303detectors
detention10169543detention
detentions11148803detentions
detentists1145503detentists
deterge9118463deterge_
deterged11127923deterged
deterger10147593deterger
detergers11147183detergers
deterred10137803deterred
deterrer9137013deterrer
deterrers10116593deterrers
deters74724683dete__rs
detest74122843detest__
detinue85010033detinue_
detonate9311193detonate_
detonated1138213detonated
detoxes1538803det_oxes
detritus945473detritus
detrudes1036193detrudes
deuterates1149073deuterates
devested13239133devested
devests114410473devest_s
deviates12312733deviates
devotes113713753de_votes
dienes75719903d_ien_es
dinettes9310193dinettes
docents102810803docent_s
doyennes1244363doyennes
dozenths2142793dozenths
duecentos1243153duecentos
duendes938193d_uendes
emeutes938013_emeutes
entente7412953entente_
ethenes103313873_ethen_es
events94814073_event_s
extents142610173extent_s
genettes938303genettes
gentes75324163__gentes
gerents82612923gerent_s
intents72115703intent_s
kentes105118643__kentes
ketene106613003keten_e_
ketones115014503keton_es
latents75214313latent_s
mementoes13325383mementoes
mementos12267373mementos
metates92720003met_ates
neotenies948383neotenies
nepenthes1444163nepenthes
octettes1045533octettes
patented1188893patented
patentee1099943patentee
patentees1196543patentees
patents94815203patent_s
pentenes10315633penten_es
petites93820203pet_ites
petuntse1042473petuntse
petuntses1142643petuntses
petuntzes2042143petuntzes
potences12710693potences
pretences132312613pretences
pretenses112210583pretenses
recenter102715443recenter
recentest11410283recentest
redenies9615713redenies
reenter73217793re_enter
reenters82915303re_enters
refences13311843refences
regents83416543regent_s
relented92614943relented
relents74018503relent_s
rentes65431193__rentes
repented112614983repented
repenter102813863repenter
repenters112511553repenters
repents93717623repent_s
rerented92516163rerented
rerents73319423rerent_s
resented92716963resented
resents74221223resent_s
retastes82212903retastes
retene69224273reten_e_
retested92212533retested
retests73813853retest_s
retines75134673retin_es
retinites9313493retinites
retinted94414363retinted
retints74717013retint_s
retinues85113153retinues
retunes76918403retun_es
revenges1238983revenges
revenues1138663revenues
selenates91611343selenates
selenites91312083selenites
sentences11610303sentences
septettes1144913septettes
serenes73222903seren_es
sevenths1444793sevenths
seventies1249673seventies
sextettes1643913sextettes
stents65019453_stent_s
tenets65518953__tenets
tenses64722553__tenses
tented74221003__tented
tenter64623933__tenter
tenters73921103__tenters
tenths94412663__tenths
tents56434213__tent_s
tenues63816443__tenues
testes65125823__testes
tetanies8513543tetanies
trientes82812123trientes
untented92613413untented
vedettes1265933vedettes
venenates1247573venenates
venenes102712133venen_es
weenies102915093we_enies
yentes95517603__yentes

Search took 9 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.1731032896.0
2DLD Change Limit1461622358.04618165.8
3Display Results2352350.1102136.4
 (SQL Overall)1786912358.32921454.1
 
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.