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 “staggard” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
staggard114451(None) 
saggard10358951s_aggard
staggards1244121staggards
staggart1046641staggart
haggard13377182_haggard
laggard10347622_laggard
saggar84010852s_aggar_
saggards11397492s_aggards
saggared11326062s_aggared
saggars93610682s_aggars
sluggard1142612sluggard
staggarts1143752staggarts
stagged104212082stagg_ed
stagger94212392stagger_
staggered1244472staggered
staggers10379842staggers
staggery13346242staggery
standard1046252standard
braggart1245613braggart
haggards14366763_haggards
jaggary19304863_jaggary
laggards11307053_laggards
niggard1044943_niggard
sagged94120013s_agg_ed
sagger84321073s_agger_
saggered11237553s_aggered
saggers94017083s_aggers
saguaro845513s_aguaro
sangar73617683s_angar_
sangars83116253s_angars
scabbard1544203scabbard
seaboard1147433seaboard
seaward1148183sea_ward
seggar8357813s_eggar_
seggars9377783s_eggars
shagbark1843113shagbark
shagged134210133shagg_ed
slagged104312773slagg_ed
sluggards1242283sluggards
snagged104010673snagg_ed
staged84521563sta_g_ed
stagehand1442973stagehand
stager74821343sta_ger_
stagers84116673sta_gers
staggerer1143923staggerer
staggie9138463stagg_ie
staggier10167513staggier
staggies101210323staggies
stagging113310513stagging
staggy115510393stagg__y
stagier83513443stagier_
stagnant946893stagnant
stagnate947243stagnate
stagnated1145143stagnated
stalwart1147193stalwart
standards1145203standards
stanged94113843stang_ed
stannary1144613stannary
stanzaed1843873stanzaed
starboard1275843starboard
stargaze1844553stargaze
stargazed2043073stargazed
statuary1144033statuary
steward1138063st_eward
stinkard1344323stinkard
straggled12296853straggled
swagged13419153swagg_ed
swagger12389333swagger_
swaggered1543193swaggered
swaggers13407223swaggers
tabard9313333_ta_bard
tagboard1245563_tagboard
taggant9310223_taggant
tagged93418123_tagg_ed
tagger84017703_tagger_
taggers93514193_taggers
tankard1267263_tankard
tanyard1167183_tanyard

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.420425454.8
2DLD Change Limit146162787.44019645.4
3Display Results78780.0302600.0
 (SQL Overall)178691787.89022647.8
 
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.