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

139 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
unagreed103682(None) 
agreed84712502__agreed
dungareed1242432dungareed
unaged83916422unag__ed
unaired82916012unair_ed
unargued1035582unargued
unarmed101811922una_rmed
unfreed11510122un_freed
ungarbed12197062ungarbed
ungreedy1342812un_greedy
agree65226033__agree_
agrees74915323__agrees
angered93013473an_gered
dangered11248513dangered
degreed10258883_degreed
disagreed1245463disagreed
dungaree1045613dungaree_
dungarees1143153dungarees
filagreed1472873filagreed
gangrened1242733gangrened
gnarled9287723gna_rled
gnarred9327013gna_rred
greed75125693___greed
hungered13217053hun_gered
inarmed10268673ina_rmed
inbreed10267643in_breed
knapweed1842443knapweed
knarred12266003kna_rred
laagered1055853laagered
lagered92311153_lagered
nacred95212493_nacr_ed
nagged93916053_nag_ged
narked114116743_na_rked
ragweed1235073_ragweed
shagreen1243443shagreen
snagged104010673snag_ged
snapweed1443453snapweed
snared74824553sna_r_ed
snarfed11378753sna_rfed
snarled83612363sna_rled
unabated11310133unabated
unaborted1245733unaborted
unabraded1344893unabraded
unabused1135623unabused
unaccrued1442693unaccrued
unacted10312733una_cted
unadded10238523una_dded
unadorned1144123unadorned
unafraid1242663unafraid
unagile838283unagile_
unaided92414603una_ided
unaimed102812493una_imed
unalarmed1244633unalarmed
unalerted1047963unalerted
unalleged1144453unalleged
unallied938393unallied
unaltered1037723unaltered
unamazed2035883unamazed
unamused1135793unamused
unaneled939793unaneled
unannexed1743543unannexed
unarched14128553unarched
unarrayed1344183unarrayed
unasked122010023una_sked
unatoned939423unatoned
unaverted1336563unaverted
unavowed1534783unavowed
unawaked1635903unawaked
unawarded1444923unawarded
unawed103914903una__wed
unaxed144113093una__xed
unbarbed13217753unbarbed
unbarred11238703unbarred
unbred92613303un_br_ed
unburied11208513unburied
unburned11227413unburned
uncaged113314123uncag__ed
uncarded12310133uncarded
uncarted11312053uncarted
uncarved1438163uncarved
uncatered1237403uncatered
uncorked152210403uncorked
uncrewed1456763un_crewed
uncurbed1346903uncurbed
uncured10513233uncur_ed
uncurled1168963uncurled
uncursed1148973uncursed
underfed13311713underfed
underfeed1448633underfeed
undried92314613un_dried
unearned9310063unearned
unfired112212453unfir_ed
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unformed14239573unformed
unfree9413203un_free_
unfrees1048643un_frees
unfurled1277203unfurled
ungalled1078463ungalled
ungated92717213un_gated
ungirded1136083ungirded
unglued937303un_glued
ungraced12239143un_graced
ungraded11209923un_graded
ungreased1136333un_greased
unhaired12238763unhair_ed
unharmed1438093unharmed
unharried1344763unharried
unhired112512153unhir_ed
unhorsed1238833unhorsed
unmarked15248813unmarked
unmarred11258403unmarred
unmarried1244583unmarried
unnerved1248063unnerved
unpaged113311043unpag__ed
unpaired11208943unpair_ed
unparted11310823unparted
unpurged1236293unpurged
unread73412673un__read
unreel63612933un__reel
unscrewed1554033unscrewed
unserved12410233unserved
unsorted9312513unsorted
untagged1135973untag_ged
unthread1244603unthread
untired82316383untir_ed
untread857413un_tread
untried82615853un_tried
unturned9228563unturned
unurged939143un_urged
unvaried1239683unvaried
unversed122310433unversed
unwarmed1437303unwarmed
unwarned1238453unwarned
unwarped1436873unwarped
unwatered1345683unwatered
unworked16238503unworked
wagered12299333_wagered

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.406440125.6
2DLD Change Limit1461621396.90621164.5
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.35824285.3
 
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.