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

117 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
dogeared114579(None) 
dogear838192dogear__
dogears937512dogear_s
dognaped1343492dognaped
dowered122811552dowe_red
geared85317742__geared
regeared1039432regeared
rogered939552roge_red
afeared1176833_afeared
aneared8512743_aneared
angered93013473ange_red
appeared1336143appeared
beggared1334753beggared
bleared104211253_bleared
bogarted1235053bog_arted
bogeyed1435673boge_yed
bowered133113043bowe_red
cleared103612463_cleared
coheaded1536603coheaded
cohered133514693cohe_red
collared113211143collared
compared153811823compared
congealed1346593congealed
covered133315293cove_red
cowered133214653cowe_red
daggered12246403daggered
dangered11248513dange_red
dared75935013d___ared
deaired9411533d__eaired
deaned84620453d__eaned
dearer74822803d__earer
deaved114916553d__eaved
debeaked1634613debeaked
debeard1137353debear_d
debearded1443373debearded
deceased1247713deceased
declared1248743declared
defeated132812163defeated
deferred13106363deferred
degermed1335453degermed
deglazed2034953deglazed
degraded12288323degraded
degreased1244713degreased
deleaded1148333deleaded
deleaved1346573deleaved
demeaned1237283demeaned
deterred10137803deterred
digested11208163digested
diseased103011713diseased
doated84118183do__ated
doctored1245623doctored
doddered1234943doddered
dogbane1135653dogbane_
dogbanes1245433dogbanes
dogcart1148043dogcar_t
dogcarts1243883dogcarts
dogearing1235763dogearing
dogface1454053dogface_
dogfaces1554143dogfaces
dogged106017703dog__ged
doggerel1143453doggerel
doggoned1243883doggoned
doggrel1033883dog_grel
doghanged1642343doghanged
doglegged1441783doglegged
dognaper1243693dognaper
dognapped1642143dognapped
dogsled1035193dog_sled
dogvane1243853dogvane_
dogvanes1344303dogvanes
donated93513863do_nated
donnered10307753donnered
dormered1255673dormered
dotard839053do_tar_d
dovened12389063dove_ned
doweled12269773dowe_led
dowelled1356343dowelled
dozened18377453doze_ned
dreaded103612023d_readed
dreamed114310633d_reamed
eared65139503___eared
endeared1038053endeared
feared106320433__feared
forearmed1544863forearmed
foveated1536293foveated
glared84715203__glared
homebred16215893homebred
homered133212713home_red
hovered143411573hove_red
lagered92311153lage_red
lowered112711913lowe_red
mongered1238953monge_red
mortared1137213mortared
neared75119803__neared
oared65030653_o__ared
overed102216623_ove_red
poleaxed1854823poleaxed
powered132911643powe_red
reared75930013__reared
roared75015393ro__ared
saggared11326063saggared
seared75232843__seared
sheared114516003_sheared
smeared104510623_smeared
soared74324293so__ared
sobered102912433sobe_red
speared104314423_speared
sugared938583sug_ared
teared75722153__teared
togaed84711343tog_a_ed
togated94410663tog_ated
towered112911403towe_red
unbeared111611653unbeared
unfeared121511013unfeared
unseared91113943unseared
upreared1137073upreared
wagered12299333wage_red

Search took 9 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.450397091.1
2DLD Change Limit1461621178.31317582.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.80920285.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.