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

192 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
deterged1112792(None) 
demerged13157601demerged
deterge9118461deterge_
deterger10147591deterger
deterges101510091deterges
deterred10137801deterred
decerned1237262decerned
deferred13106362deferred
degermed1335452degermed
demerge11168022demerge_
demerger12127372demerger
demerges12129502demerges
depermed1436452depermed
deserted101012202deserted
deserved13108132deserved
detected12289732detected
detergent11129572detergent
detergers11147182detergers
deterrer9137012deterrer
detested10279622detested
diverged14256882diverged
emerged11158212_emerged
metered103514012meter_ed
petered103314972peter_ed
remerged12149172remerged
absterged1353353absterged
altered83215753alter_ed
bettered113011843better_ed
catered103117783cater_ed
centered112513523center_ed
deaerated11311123deaerated
deaired9411533deair_ed
debagged1433723debagged
debarked16175833debarked
debarred12165643debarred
debeaked1634613debeaked
debearded1443373debearded
debugged1433223debugged
deceased1247723deceased
deceived1535893deceived
decreed112710263de_creed
decried112612863de_cried
decurved1534843decurved
deeded94615543de_e_ded
deemed104713063de_e_med
deerweed1344193de_erweed
defanged1435433defanged
defeated132812163defeated
defected15289973defected
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferrer12135593deferrer
defogged1533783defogged
deforced15247373deforced
deformed15248263deformed
degreed10258883de_greed
dehorned1345683dehorned
dehorted1357303dehorted
dejected19307593dejected
deleaded1148333deleaded
deleaved1346573deleaved
deleted93314913dele_ted
deluged10167413de_luged
demarked16187223demarked
demeaned1237283demeaned
demented12311273demented
demergered1543173demergered
demergers13146403demergers
demerited1339073demerited
demurred1234933demurred
departed1238823departed
depended1337983depended
deported1249703deported
deranged1137693deranged
descried1248083descried
deserter91211603deserter
deserve11108703deserve_
deserver12118383deserver
deserves12109893deserves
desexed1636183dese_xed
desired9311983desir_ed
desorbed1236443desorbed
detached1537733detached
detailed10319873detailed
detained103111643detained
detecter11298733detecter
detente83313603detente_
detentes92712873detentes
deter65028043deter___
detergency1754183detergency
detergents12116663detergents
deterging1237853deterging
determent121312903determent
determined1455823determined
deterrent10128943deterrent
deterrers10116593deterrers
deters74724683deter__s
detester9239683detester
dethroned1445073dethroned
deticked1635693deticked
detoured1036513detoured
detoxed1636103det_oxed
detrude936083det_rude
detruded1134883detruded
deuterated1247543deuterated
deuteride1145543deuteride
deveined1336673deveined
develed123611933deve_led
devested13239133devested
dewatered1444743dewater_ed
dewormed15236223dewormed
dithered13189293dither_ed
diverge12347643diverge_
diverges13258313diverges
diverted13199583diverted
dowered122811553dower_ed
dredged11346893d_redged
emerge91510463_emerge_
emerges101310883_emerges
emersed10138513_emersed
energid948303_energid
entered82718883enter_ed
eterne6311723_eterne_
everted112711853_everted
exerted152210053_exerted
festered122512113fester_ed
fettered12259493fetter_ed
fevered14339723fever_ed
gettered10258613getter_ed
immerged1444023immerged
interbed112413103interbed
interned93016653interned
interred92615263interred
jeered143912793je_er_ed
leered73816223le_er_ed
lettered92910783letter_ed
leveraged1463783leveraged
levered114212303lever_ed
merged104214953__merged
meterage1147933meterage_
meterages1248183meterages
metred95315143met_r_ed
mitered103213233miter_ed
neutered937423neuter_ed
peered93819493pe_er_ed
peltered112510453pelter_ed
pestered112814973pester_ed
reemerged1354403reemerged
refereed12149693refereed
referred1297833referred
reforged13268703reforged
regorged11227333regorged
remerge10148923remerge_
remerges111110203remerges
reneged92010763rene_ged
repegged1334893repegged
reperked15177793reperked
reserved121010583reserved
resurged1038623resurged
retagged1136063retagged
retarded102410753retarded
retarget9312743retarget
reteamed1138013reteamed
retested92212533retested
retired84620143retir_ed
retorted9312333retorted
retried84419163ret_ried
returned9459133returned
revenged1337553revenged
reverbed14269223reverbed
revered112819333rever_ed
reversed122711613reversed
reverted122714713reverted
rezeroed1835993rezeroed
secerned1136103secerned
serged84118773__serged
severed113513863sever_ed
sewered112911243sewer_ed
steered83615253steer_ed
teetered9258303teeter_ed
tentered96412103tenter_ed
termed94816703__termed
tethered1238493tether_ed
undeterred1263833undeterred
uttered82712443utter_ed
veered103612743ve_er_ed
verged114815163__verged
waterbed1436453waterbed
watered113014963water_ed
weltered12238443welter_ed
westered122511873wester_ed

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.423422437.4
2DLD Change Limit1461621927.32619951.1
3Display Results1921920.0802400.0
 (SQL Overall)1786911927.82922824.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.