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

174 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
deterges10151009(None) 
demerges12129501demerges
deterge9118461deterge_
deterged11127921deterged
deterger10147591deterger
detergers11147181detergers
demerge11168022demerge_
demerged13157602demerged
demerger12127372demerger
demergers13146402demergers
deserves12109892deserves
detentes92712872detentes
detergent11129572detergent
detergents12116662detergents
deterred10137802deterred
deterrer9137012deterrer
deterrers10116592deterrers
deters74724682deter__s
diverges13258312diverges
emerges101310882_emerges
meterages1248182meterages
remerges111110202remerges
absterges1244763absterges
arteries8321483arteries
asperges11318093asperges
auberges1146673auberges
beverages1595223beverages
celeries10316313celeries
coteries10422703coteries
dataries9314033dataries
daters74827373dater__s
deaerates10313643deaerates
deaneries10310833deaneries
dearies83526273de_aries
decares102818533decar_es
deceases11410153deceases
deceives1437903deceives
decerned1237263decerned
decerns10119053decer_ns
decrees102513123de_crees
decries103319803de_cries
decuries11312223decuries
decurves1435863decurves
deers64930523de_er__s
defences1439633defences
defenses1237913defenses
deferred13106363deferred
deferrer12135593deferrer
deferrers13115153deferrers
defers105116943defer__s
deforces14248403deforces
degermed1335453degermed
degerms1135623deger_ms
degrees92810723de_grees
dekares122710873dekar_es
deleaves1248063deleaves
deletes83117933dele_tes
deluges9169263de_luges
demerits11310763demerits
demesnes1137083demesnes
demiurges1343863demiurges
dentures9312453dentur_es
depermed1436453depermed
deperms1236603deper_ms
deranges1039973deranges
derries83124623de_rries
descries11311923descries
deserted101012203deserted
deserter91211603deserter
deserters10129983deserters
deserts82513053deser_ts
deserve11108703deserve_
deserved13108133deserved
deserver12118383deserver
deservers13107293deservers
desexes1537833dese_xes
desires81316133desir_es
detaches1439653detaches
detected12289733detected
detecter11298733detecter
detecters12217753detecters
detects104011093dete_cts
detente83313603detente_
detents83615153dete_nts
deter65028043deter___
detergency1754183detergency
deterging1237853deterging
determent121312903determent
determents131010313determents
determines1358433determines
deterrent10128943deterrent
deterrents11126473deterrents
detersives1444953detersives
detested10279623detested
detester9239683detester
detesters10298303detesters
detests83711743dete_sts
dethrones1347313dethrones
detinues9569823detinues
detoxes1538803det_oxes
detrudes1036203detrudes
deuterates1149083deuterates
deuterides1245253deuterides
deuterons1046783deuterons
dexterous1745553dexterous
dietaries10410663dietaries
dieters83216433dieter__s
dirges84915103d__irges
diverge12347643diverge_
diverged14256883diverged
dotages92311793dot_ages
doters74423913doter__s
doweries12411933doweries
dredges10379343d_redges
duperies11312813duperies
eateries8324313eateries
emerge91510463_emerge_
emerged11158213_emerged
emeries91620023_emeries
energies9310783_energies
epergnes1156713_epergnes
eterne6311723_eterne_
exergues1644123_exergues
externes1539833externes
heteros10312683heter_os
heteroses12410783heteroses
immerges1345393immerges
internes82721233internes
ketenes114813503kete_nes
leverages1365663leverages
merges94122483__merges
metages102714973met_ages
meterage1147933meterage_
metered103514013meter_ed
meters85625833meter__s
metres85121563met_r_es
niteries8318383niteries
peerages1189893pe_erages
peeries93623023pe_eries
petered103314963peter_ed
peters86624593peter__s
reemerges1255173reemerges
referees111310413referees
reforges12249333reforges
regorges10238413regorges
remerge10148923remerge_
remerged12149173remerged
reneges82513593rene_ges
reserves111011983reserves
resurges9310123resurges
retarget9312743retarget
retargets1045303retargets
retenes76324623rete_nes
retirees84611653retirees
retires74726213retir_es
retries74129073ret_ries
revenges1238983revenges
reveres103621343rever_es
reveries112518513reveries
reverses112513513reverses
rezeroes1737143rezeroes
serges74225963__serges
sesterces1147873sesterces
sewerages1345363sewerages
steerages1046493steerages
steres63929533_ster_es
targes74524593__targes
terces83921413__terces
ternes65422903__ternes
veeries102916893ve_eries
veneries112815033veneries
verges104320173__verges
veterans1148853veterans
waterages1349383waterages

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 Limit1461621747.75018859.6
3Display Results1741740.0602900.0
 (SQL Overall)1786911747.96622431.7
 
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.