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

173 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
deterge911846(None) 
demerge11168021demerge
deterged11127921deterged
deterger10147591deterger
deterges101510091deterges
demerged13157602demerged
demerger12127372demerger
demerges12129502demerges
deserve11108702deserve
detente83313602detente
deter65028042deter__
detergent11129572detergent
detergers11147182detergers
deterred10137802deterred
deterrer9137012deterrer
deters74724682deter_s
diverge12347642diverge
emerge91510462_emerge
eterne6311722_eterne
meterage1147932meterage
remerge10148922remerge
absterge1154083absterge
auberge1045633auberge
beverage1445143beverage
coterie9417403coterie
dater65332313dater__
daters74827373dater_s
deaerate9314173deaerate
dearie73319813de_arie
decare93919153decar_e
decease1049523decease
deceive1337813deceive
decern91310953decer_n
decerned1237263decerned
decerns10119053decerns
decree93117783de_cree
decurve1335583decurve
deer56739023de_er__
deers64930523de_er_s
defence1339893defence
defense1137503defense
defer94619753defer__
deferred13106363deferred
deferrer12135593deferrer
defers105116943defer_s
deforce13267243deforce
defter104215923defter__
degage92711383de_gage
degerm1037893deger_m
degermed1335453degermed
degerms1135623degerms
degree82814853de_gree
dekare112811563dekar_e
deleave1147723deleave
delete73620703dele_te
deluge8189403de_luge
demergers13146403demergers
demerit10314993demerit
demesne1035573demesne
demiurge1243873demiurge
demure9311533demur_e
denture8311893dentur_e
deperm1139363deper_m
depermed1436453depermed
deperms1236603deperms
derange939813derange
dere56845903d__er_e
desert72725493deser_t
deserted101012203deserted
deserter91211603deserter
deserts82513053deserts
deserved13108133deserved
deserver12118383deserver
deserves12109893deserves
desire7415303desir_e
detect94217403dete_ct
detected12289733detected
detecter11298733detecter
detects104011093detects
detent73624483dete_nt
detentes92712873detentes
detents83615153detents
detergency1754183detergency
detergents12116663detergents
deterging1237853deterging
determent121312903determent
determine1249033determine
deterrent10128943deterrent
deterrers10116593deterrers
detersive1346343detersive
detest74122843dete_st
detested10279623detested
detester9239683detester
detests83711743detests
dethrone1247563dethrone
detinue85010033detinue
detrude936083detrude
deuterate1049513deuterate
deuteric1146343deuteric
deuteride1145543deuteride
deuteron945993deuteron
dexter143810893dexter__
dieter73516773dieter__
dieters83216433dieter_s
dirge75117073d__irge
diverged14256883diverged
diverges13258313diverges
diverse11429993diverse
dotage82711613dot_age
doter65428623doter__
doters74423913doter_s
dredge9308563d_redge
eerie55228533_e_erie
emerged11158213_emerged
emerges101310883_emerges
energy10137513_energy
epergne1046143_epergne
exergue1544193_exergue
externe1438573externe
hetaerae1145533hetaerae
hetero9312633heter_o
heteros10312683heteros
immerge1244703immerge
interage9314493interage
interne73218153interne
ketene106613003kete_ne
leverage1285393leverage
merge84523693__merge
metage93114453met_age
meter75130323meter__
meterages1248183meterages
metered103514013metered
meters85625833meter_s
metre74821303met_r_e
niterie7313743niterie
peerage1089803pe_erage
peerie83617893pe_erie
peter74427593peter__
petered103314973petered
peters86624593peter_s
reemerge1154793reemerge
referee101615753referee
reforge11259033reforge
regorge9257833regorge
remerged12149173remerged
remerges111110203remerges
renege72713763rene_ge
reserve101011203reserve
resurge839073resurge
retarget9312743retarget
retene69224273rete_ne
retire64927013retir_e
retiree75019083retiree
retore67630773retor_e
revenge1138573revenge
revere94621253rever_e
reverie103615163reverie
reverse103913743reverse
serge64727473__serge
sesterce1047113sesterce
severe94016083sever_e
sewerage1245513sewerage
steerage946833steerage
stere55328543_ster_e
targe65227093__targe
tenge65720443__tenge
terce75721843__terce
terga63315643__terga
terne56426153__terne
terse55026823__terse
verge93419843__verge
veteran1039353veteran
waterage1248663waterage

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.403443402.0
2DLD Change Limit1340271736.36021073.4
3Display Results1731730.0632746.0
 (SQL Overall)1786911736.82626178.0
 
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.