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

132 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
defogged153378(None) 
befogged1643151befogged
defogger1443531defogger
debagged1433722debagged
debugged1433222debugged
defanged1435432defanged
defoamed15356242defoamed
defoggers1543052defoggers
deforced15247372deforced
deformed15248262deformed
defragged1643042defragged
dogged106017702d__ogged
fogged125518372__fogged
reforged13268702reforged
beclogged1643143beclogged
beflagged1742423beflagged
befooled1434803befooled
befouled1434683befouled
begged115013813be__gged
begoggled1541713begoggled
belonged1235313belonged
berouged1235323berouged
bewigged1643383bewigged
bogged116019283__bogged
clogged12528653_clogged
cogged116416613__cogged
deboned113411633debo_ned
debugger1343123debugger
decocted1437683decocted
decoded123212383deco_ded
decoyed14358333deco_yed
defaced142910973def_aced
defamed14309833def_amed
defatted1335673defatted
defeated132812163defeated
defected15289973defected
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferred13106363deferred
defied115016383def__ied
defiled124013103def_iled
defined123813823def_ined
deflated133412303deflated
defleaed1344953defleaed
deflexed2043883deflexed
defoamer14276213defoamer
defocused16143533defocused
defog1048523defo_g__
defogging1653863defogging
defogs1156683defo_g_s
deforce13267243deforce_
deforcer14246903deforcer
deforces14248403deforces
deformer14247943deformer
defragger1542603defragger
defrayed1635403defrayed
defrocked2043053defrocked
defrosted1444253defrosted
defueled1374513defueled
defunded1435163defunded
defused125211093def_used
defuzed21447043def_uzed
dehorned1345683dehorned
dehorted1357303dehorted
deigned1037503de_igned
deloused1036973deloused
deluged10167413de_luged
demagoged15103643demagoged
demerged13157603demerged
demobbed1643203demobbed
demoded123611123demo_ded
demoed103713443demo__ed
demoted114313543demo_ted
denoted93512763deno_ted
deponed113712873depo_ned
deported1249703deported
deposed113412023depo_sed
deranged1137693deranged
derogated1238673derogated
designed1136943designed
desorbed1236443desorbed
deterged11127923deterged
detoured1036513detoured
detoxed1636103deto_xed
devoiced15276063devoiced
devolved16325513devolved
devoted124111093devo_ted
devoured1335723devoured
dewooled1333833dewooled
dewormed15236223dewormed
digged104314653d__igged
dodged107514693d__odged
dogger95216783d__ogger
dragged11379563d_ragged
drugged11367183d_rugged
egged85114393_e__gged
fagged124717703__fagged
figged124013893__figged
flogged13528803_flogged
fogger114414783__fogger
forged115519323__forged
frogged13408493_frogged
fugged124615383__fugged
hogged125817773__hogged
jogged166015923__jogged
kegged13469263ke__gged
legged95713093le__gged
logged96622943__logged
mogged115215393__mogged
nogged95716333__nogged
pegged114811913pe__gged
progged12409803_progged
reflagged1543093reflagged
refolded1337063refolded
reforge11259033reforge_
reforges12249333reforges
reformed14249603reformed
refuged125410873ref_uged
regorged11227333regorged
rejigged1833683rejigged
renigged1135053renigged
repegged1334893repegged
rerigged1136243rerigged
retagged1136063retagged
shogged13397963_shogged
slogged104910473_slogged
snogged10417973_snogged
sogged95518523__sogged
togged95117513__togged
unforged13238623unforged
vegged124910023ve__gged

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 Limit1461621327.04620744.0
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.51523777.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.