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

186 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
saggard1035895(None) 
haggard13377181haggard
laggard10347621laggard
saggar84010851saggar_
saggards11397491saggards
saggared11326061saggared
saggars93610681saggars
staggard1144511staggard
haggards14366762haggards
jaggary19304862jaggary
laggards11307052laggards
niggard1044942niggard
sagged94120012sagg_ed
sagger84321072sagger_
saggered11237552saggered
saggers94017082saggers
saguaro845512saguaro
sangar73617682sangar_
sangars83116252sangars
seggar8357812seggar_
seggars9377782seggars
sluggard1142612sluggard
staggards1244122staggards
staggart1046642staggart
aboard9312613_aboard
afeard1058263_afeard
agar58726413_a_gar_
agars66120643_a_gars
aggada955223_aggada
agger76420893_agger_
aggers85817793_aggers
aggrade1035643_aggrade
aggro738013_agg_ro
aglare7312423_aglare
angary10311323_angary
award97118043_a_ward
baggage1235633baggage
bagged114519903bagg_ed
bagger104619203bagger_
baggers113915693baggers
bastard103012423bastard
bayard124411663ba_yard
beggar10328223beggar_
beggared1334753beggared
beggars11378223beggars
beggary14316153beggary
braggart1245613braggart
canard9314763ca_nard
dagga839543dagga__
daggas937973dagga_s
dagger95017303dagger_
daggered12246403daggered
daggers103714913daggers
daggled11329463daggled
dastard9279703dastard
eggar7458883_eggar_
eggars8398973_eggars
fagged124717703fagg_ed
gabbard1336553gabbard
gagged104817153gagg_ed
gagger95016513gagger_
gaggers103413663gaggers
gaggled11359913gaggled
guard74415543__guard
haggada1353643haggada
haggardly1842673haggardly
hagged124317703hagg_ed
haggled13359283haggled
halyard1476973halyard
hangar104114513hangar_
hangared1337573hangared
hangars114313493hangars
hayward1736413hayward
hazard1938403ha_zard
jagged164115353jagg_ed
jagger154016003jagger_
jaggers164012893jaggers
jaggery19336903jaggery
jaguar1435283jaguar_
jaguars1535233jaguars
laggardly1542673laggardly
lagged95520133lagg_ed
lagger85919833lagger_
laggers94216243laggers
laniard868523laniard
lanyard1167293lanyard
mallard10310273mallard
mansard1049313mansard
manward1349093manward
mazard1838763ma_zard
mazzard1844463mazzard
muggar10316443muggar_
muggars11316643muggars
nagged93916053nagg_ed
nagger84016123nagger_
naggers93812653naggers
niggards1144123niggards
ragged94620263ragg_ed
regard85215773_regard
safari91110223sa_fari
safeguard1452083safeguard
saga55331173sa_ga__
sagas66025883sa_ga_s
sager65432053sa_ger_
saggaring12236243saggaring
saggier92912063saggier
sagging103116103sagging
saggy105917463sagg__y
sagier73717163sagier_
saguaros944973saguaros
sahuaro1044233sahuaro
saiga64717933saiga__
saigas74114293saiga_s
salad65321833sa_la_d
salary9515213sa_lary
samara8313853sa_mara
sambaed1238303sambaed
sambar103914163sambar_
sambars115113843sambars
samsara936913samsara
sanga66023793sanga__
sangaree949333sangaree
sangas75222653sanga_s
sanger74524563sanger_
sangers84421943sangers
sansar63613393sansar_
sansars73313913sansars
sard55344243s___ard
sardar73013173sardar_
sardars83112903sardars
sarsar63011843sarsar_
sarsars73512143sarsars
satara6315533sa_tara
sauger74316253sauger_
saugers83914053saugers
saunaed836703saunaed
savaged1236993savaged
scabbard1544203scabbard
seaboard1147433seaboard
seaward1148183seaward
shagbark1843113shagbark
shagged134210133shagg_ed
shard96125963s__hard
skyward1843863skyward
slagged104312773slagg_ed
sluggards1242283sluggards
snagged104010673snagg_ed
sogged95518523sogg_ed
staggarts1143753staggarts
stagged104212083stagg_ed
stagger94212393stagger_
staggered1244473staggered
staggers10379843staggers
staggery13346243staggery
standard1046253standard
steward1138063steward
sugar6312913s_ugar_
sugared938583s_ugared
sugars7312423s_ugars
sugary1039013s_ugary
sunward1137653sunward
swagged13419153swagg_ed
swagger12389333swagger_
swaggered1543193swaggered
swaggers13407223swaggers
sward94221463s__ward
tabard9313333ta_bard
tagboard1245563tagboard
taggant9310223taggant
tagged93418123tagg_ed
tagger84017703tagger_
taggers93514193taggers
tankard1267263tankard
tanyard1167183tanyard
unguard955093unguard
vagary1337333va_gary
vanguard1343893vanguard
vanward1456943vanward
vaward13498723va_ward
wagged124616123wagg_ed
wagger113616013wagger_
waggers124613083waggers
waggery15276903waggery
waggled13389363waggled
wayward1736053wayward
zagged183612513zagg_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 Filter1786911340270.406440125.6
2DLD Change Limit1340271866.98319193.3
3Display Results1861860.0802325.0
 (SQL Overall)1786911867.46923924.4
 
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.