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

256 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
detente8331360(None) 
detent73624481detent_
detentes92712871detentes
detents83615151detents
decent94023702decent_
decenter112412162decenter
decentre11248552decentre
defence1339892defence
defense1137502defense
delete73620702dele_te
dement93825152dement_
demented12311272demented
dements103016622dements
detect94217402detect_
detected12289732detected
detecter11298732detecter
detects104011092detects
deterge9118462deterge
detest74122842detest_
detested10279622detested
detester9239682detester
detests83711742detests
detinue85010032detinue
detonate9311192detonate
entente7412952entente
ketene106613002keten_e
retene69224272reten_e
attent62818323attent_
butene8312623buten_e
catenae9311373catenae
catenate10312833catenate
celeste949653celeste
cement103321673cement_
cementa112810543cementa
cemented1338373cemented
cementer1239193cementer
cements112714223cements
cetane8315283cetan_e
deaerate9314173deaerate
dealate83617843dealate
debate94419193de_bate
debenture1243473debenture
debone93714783debon_e
debutante1243223debutante
decane93818873decan_e
decant93524223decant_
decanted122310493decanted
decanter112510793decanter
decants103514443decants
decease1049523decease
deceit93018213deceit_
deceits102810883deceits
deceive1337813deceive
decency1537453decency
decenters122410373decenters
decentest1249083decentest
decently1448013decently
decentred13236233decentred
decentres12238523decentres
deet57356583de_e_t_
deets65330243de_e_ts
defeat103817163defeat_
defeated132812163defeated
defeater122611663defeater
defeats113511233defeats
defecate1438793defecate
defect124816173defect_
defected15289973defected
defects134511523defects
defenced1537203defenced
defences1439633defences
defend113910493defen_d
defended1437223defended
defender1337293defender
defends12358773defends
defensed1336223defensed
defenses1237913defenses
define104718143defin_e
definite1239323definite
deflate113613943deflate
deftest112611713deftest_
degender1136893degender
deject164512843deject_
dejecta17376363dejecta
dejected19307593dejected
dejects17389223dejects
delate73827753de_late
deleave1147723deleave
delegate10410463delegate
deleted93314913dele_ted
deletes83117933dele_tes
dementia1157833dementia
demerge11168023demerge
demesne1035573demesne
demote94817803de_mote
dene56643413d__en_e
denote74118043de_note
dense65923503d__ense
dent57158413d__ent_
dentate8315153dentate
dented84120513d__ented
dentine83320243dentin_e
dents65031803d__ents
depend103510923depen_d
depended1337983depended
depends11348993depends
deplete103010423deplete
depone93616553depon_e
depute94512303de_pute
derange939813derange
derate74531233de_rate
descent102616293descent_
descents112511203descents
desert72725493desert_
deserted101012203deserted
deserter91211603deserter
deserts82513053deserts
deserve11108703deserve
despite10410123despite
destine83719953destin_e
detainee92511723detainee
detecters12217753detecters
detective1548103detective
detector11278323detector
detention10169543detention
detentist1049323detentist
deter65028043dete__r
deterged11127923deterged
deterger10147593deterger
deterges101510093deterges
deterred10137803deterred
deterrer9137013deterrer
deters74724683dete_rs
detesters10298303detesters
detinues9569823detinues
detonated1138213detonated
detonates10310433detonates
detrude936083detrude
deuterate1049513deuterate
devest104418703devest_
devested13239133devested
devests114410473devests
deviate11312713deviate
devote104513783de_vote
diene65720133d_ien_e
dinette8310013dinette
distent84120853distent_
docent92918683docent_
docents102810803docents
doyenne1143883doyenne
dozenth2044323dozenth
duecento1143563duecento
duende836923d_uende
emeute838533_emeute
ententes8312773ententes
eterne6311723_eterne
ethene93312923_ethen_e
event85924443_event_
events94814073_events
extent132714913extent_
extents142610173extents
genette838863genette
gerent73223103gerent_
gerents82612923gerents
intense72511903intense
intent63122773intent_
intents72115703intents
kente95821073__kente
ketenes114813503ketenes
ketone105014533keton_e
latent64124303latent_
latents75214313latents
licente91210893licente
lisente71210703lisente
memento11378133memento
metate82720533met_ate
nepenthe1343543nepenthe
octette946423octette
patent84524923patent_
patented1188893patented
patentee1099943patentee
patents94815203patents
pentene9313793penten_e
petite84320653pet_ite
petuntse1042473petuntse
petuntze1942243petuntze
potence11711363potence
potent84223353potent_
pretence122312123pretence
pretense10199823pretense
recent83630853recent_
recenter102715443recenter
reenter73217793re_enter
refence12312233refence
regent74127673regent_
regents83416543regents
relent64431853relent_
relented92614943relented
relents74018503relents
rente54733783__rente
repent84728873repent_
repented112614983repented
repenter102813863repenter
repents93717623repents
rerent63832453rerent_
rerented92516163rerented
rerents73319423rerents
resent63833623resent_
resented92716963resented
resents74221223resents
retaste72313133retaste
retenes76324623retenes
retentive1249853retentive
retest64028453retest_
retested92212533retested
retests73813853retests
retinae75517333retinae
retine66237333retin_e
retinite8314853retinite
retint65633443retint_
retinted94414363retinted
retints74717013retints
retinue75414843retinue
retune69121953retun_e
revenge1138573revenge
revenue1039533revenue
selenate81712533selenate
selenite81713113selenite
sente56432883__sente
sentence1099863sentence
septette1044763septette
serenate81914883serenate
serene63522353seren_e
seventh1336773seventh
seventy1338033seventy
sextette1544073sextette
stent55634513_stent_
stents65019453_stents
tenet55542213__tenet
tenge65720443__tenge
tense55225843__tense
tent46159863__tent_
tented74221003__tented
tenter64623933__tenter
tenth85421833__tenth
tentie62521183__tentie
tents56434213__tents
tenty86121603__tenty
terete6319333tere_te
untented92613413untented
vedette1166003vedette
vegete1039483vege_te
venenate1147933venenate
venene92912523venen_e
weenie92612023we_enie
yente86220043__yente

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272566.01622278.4
3Display Results2562560.0932752.7
 (SQL Overall)1786912566.52927368.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.