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

119 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
saggared1132606(None) 
saggard10358951saggar_d
saggered11237551saggered
beggared1334752beggared
daggered12246402daggered
haggard13377182haggar_d
hangared1337572hangared
laggard10347622laggar_d
saggar84010852saggar__
saggards11397492saggards
saggars93610682saggar_s
sagged94120012sagg__ed
sangaree949332sangaree
staggard1144512staggar_d
staggered1244472staggered
sugared938582s_ugared
swaggered1543192swaggered
afeared1176833_afeared
aggrade1035643_aggrade
aggraded1244203_aggraded
aglare7312423_aglare_
aneared8512743_aneared
angered93013473_angered
ascared10399523_ascared
ashlared1253933ashlared
augured987193_augured
badgered1336213badgered
baggage1235633baggage_
baggages1335443baggages
bagged114519903bagg__ed
buggered1335623buggered
daggled11329463dagg_led
dangered11248513dangered
dogeared1145793dogeared
fagged124717703fagg__ed
faggoted1443103faggoted
gagged104817153gagg__ed
gaggled11359913gagg_led
geared85317743__geared
glared84715193__glared
haggards14366763haggards
hagged124317703hagg__ed
haggled13359283hagg_led
jaggaries18135743jaggaries
jaggary19304863jaggar_y
jagged164115353jagg__ed
jiggered1834203jiggered
laagered1055853laagered
lagered92311153la_gered
laggards11307053laggards
lagged95520133lagg__ed
nagged93916053nagg__ed
niggard1044943niggar_d
niggarded1342643niggarded
puggaree12174333puggaree
ragged94620263ragg__ed
regeared1039433regeared
sabered103213023sa_bered
sabred95916533sa__bred
sacred94917103sa__cred
safaried1236253sa_faried
sagamen10127503sa_gamen
saggaring12236243saggaring
sagger84321073sagg__er
saggers94017083sagger_s
saggier92912063sagg_ier
saguaro845513saguar_o
saguaros944973saguaros
salaamed1134623salaamed
salaried9311023sa_laried
salvaged1335363salvaged
sambaed1238303samba_ed
sandaled1039243sandaled
sangar73617683sangar__
sangarees1046543sangarees
sangars83116253sangar_s
sashayed1543553sashayed
satiated9311603satiated
saunaed836703sauna_ed
savaged1236993sa_vaged
savored1158343sa_vored
savoured1234793savoured
scared95227293s__cared
seared75232843s__eared
seggar8357813seggar__
seggars9377783seggar_s
shagged134210133shagg__ed
shared105829063s__hared
sheared114516003s_heared
signaled1035393signaled
slagged104312773slagg__ed
slugabed12102783slugabed
sluggard1142613sluggar_d
smeared104510623s_meared
snagged104010673snagg__ed
snared74824553s__nared
sniggered1243443sniggered
soared74324293s__oared
sogged95518523sogg__ed
spared95427493s__pared
speared104314423s_peared
squared173610563s_quared
staggards1244123staggards
staggart1046643staggar_t
staggarts1143753staggarts
stagged104212083stagg__ed
staggerer1143923staggerer
stagnated1145143stagnated
stared75429873s__tared
stargazed2043073stargazed
sugarer837323s_ugarer
swagged13419153swagg__ed
swaggerer1442943swaggerer
tagged93418123tagg__ed
wagered12299333wa_gered
wagged124616123wagg__ed
waggled13389363wagg_led
waggoned1443253waggoned
zagged183612513zagg__ed

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.1561145455.1
2DLD Change Limit1461621197.86018595.7
3Display Results1191190.0462587.0
 (SQL Overall)1786911198.06222164.6
 
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.