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

184 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
defanged143543(None) 
deranged1137691deranged
danged94819482d__anged
deaned84620452de_an_ed
debagged1433722debagged
decanted122310492decanted
defaced142910972defa_ced
defamed14309832defa_med
defang1137752defang__
defangs1235362defang_s
defatted1335672defatted
defenced1537202defenced
defended1437222defended
defensed1336222defensed
defined123813822defin_ed
defogged1533782defogged
defragged1643042defragged
defunded1435162defunded
demanded13348512demanded
derange939812derange_
deranger1037352deranger
deranges1039972deranges
desanded11227452desanded
fanged114318222__fanged
rehanged1357832rehanged
arranged1036933arranged
banged104923723__banged
beaned95621473be_an_ed
befinger1434643befinger
beflagged1742423beflagged
befogged1643153befogged
befringed16123863befringed
belonged1235313belonged
beringed1298173beringed
bewinged1584473bewinged
changed144214143_changed
clanged114212653_clanged
damaged1257463dama_ged
danced105315253d__anced
danger83722823d__anger
dangled104013153d__angled
deafened1335853deafened
deaired9411533de_aired
deashed123411303de_ashed
deaved114916553de_a_ved
debarked16175823debarked
debarred12165633debarred
debased113310583deba_sed
debated113916083deba_ted
deboned113411633debon_ed
debugged1433223debugged
debunked1633193debunked
decamped1634963decamped
decane93818873decan_e_
decanes103118913decan_es
decanter112510793decanter
decayed14309333deca_yed
deface123113863defa_ce_
defacer132810363defa_cer
defaces133213403defa_ces
defame123212433defa_me_
defamer132710323defa_mer
defames132812253defa_mes
defanging1535333defanging
defaulted1443313defaulted
defeated132812163defeated
defected15289973defected
defence1339893defence_
defences1439633defences
defend113910493defen__d
defender1337293defender
defense1137503defense_
defenses1237913defenses
deferred13106363deferred
defiance1477633defiance_
defiances1557033defiances
defied115016383def__ied
defiled124013103def_iled
define104718143defin_e_
definer114413773defin_er
defines114118683defin_es
deflated133412303deflated
defleaed1344953defleaed
deflexed2043883deflexed
defoamed15356243defoamed
defogger1443533defogger
deforced15247373deforced
deformed15248263deformed
defragger1542603defragger
defrauded1542823defrauded
defrayed1635403defrayed
defueled1374513defueled
defund11447983defun__d
defused125211093def_used
defuzed21447043def_uzed
degage92711383dega_ge_
degassed11275963degassed
deigned1037503deign_ed
delated93722873dela_ted
delayed123310763dela_yed
deluged10167413de_luged
demagoged15103643demagoged
demand104314253deman__d
demander12238723demander
demarked16187223demarked
demasted1238763demasted
demeaned1237283demean_ed
demented12311273demented
demerged13157603demerged
denied84318633de__nied
denned84215633de__nned
dented84120513de__nted
depainted1375843depainted
departed1238823departed
depended1337983depended
deplaned1238663deplan_ed
deponed113712873depon_ed
deraigned1244093deraigned
derailed102410403derailed
derangers1136703derangers
derated93623503dera_ted
deratted1048403deratted
deringer1038143deringer
desalted1038313desalted
desand84812633desan__d
descanted1336673descanted
designed1136943designed
detached1537733detached
detailed10319873detailed
detained103111643detained
deterged11127923deterged
devalued1335013devalued
dewaxed19316053dewa_xed
dezinced2183903dezinced
dinged95221783d__inged
doghanged1642343doghanged
dragged11379563d_ragged
dunged95414693d__unged
evangel1134303_evangel
fadged124712363__fadged
fagged124717703__fagged
fanned104117473__fanned
firefanged1851923firefanged
flanged123810843_flanged
ganged94619193__ganged
hanged114222393__hanged
jeaned143813463je_an_ed
leaned73422543le_an_ed
levanted1245323levanted
melange1038363melange_
melanges1138613melanges
newfangled186823newfangled
panged104722333__panged
penanced1338163penanced
pranged114512553_pranged
ranged84824313__ranged
recaned102817203recan_ed
recanted112513513recanted
rechanged1646853rechanged
refaced133713573refa_ced
refenced1438993refenced
refined114720003refin_ed
reflagged1543093reflagged
reforged13268703reforged
refuged125410873ref_uged
refunded1336953refunded
regauged1135143regauged
rehinged1336853rehinged
relanded102410463relanded
remanded123011323remanded
remanned11319353remanned
retagged1136063retagged
revenged1337553revenged
slanged94112853_slanged
stanged94113843_stanged
tanged84622493__tanged
teenaged10105133teenaged
tenanted937043tenanted
twanged12387273_twanged
unhanged13258833unhanged
venged114011993ve__nged
weaned103816153we_an_ed
whanged15447613_whanged
yeaned103813903ye_an_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 Limit1461621847.47019566.5
3Display Results1841840.0632920.6
 (SQL Overall)1786911847.95622459.9
 
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.