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

187 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
daggered1224640(None) 
dangered11248511dangered
saggered11237551saggered
angered93013472_angered
badgered1336212badgered
buggered1335622buggered
dackered16116892dackered
dagger95017302dagger__
daggers103714912dagger_s
daggled11329462dagg_led
daikered1495222daikered
dandered112110962dandered
doggerel1143452doggerel
jiggered1834202jiggered
laagered1055852laagered
lagered92311152la_gered
saggared11326062saggared
staggered1244472staggered
swaggered1543192swaggered
wagered12299332wa_gered
adhered1239233_adhered
agger76420893_agger__
aggers85817793_agger_s
agreed84712503_agre_ed
altered83215733_altered
angeled93211513_angeled
augured987193_augured
bagged114519903bagg__ed
bagger104619203bagger__
baggers113915693bagger_s
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
beggared1334753beggared
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043ca_pered
careered1139493careered
catered103117773ca_tered
daggering13246113daggering
daggle93711903dagg_le_
daggles103611913dagg_les
dampened1435623dampened
danged94819483dang__ed
danger83722823danger__
dangers94818213danger_s
dangled104013153dang_led
dapperer1335763dapperer
dared75935013da___red
darkened1435943darkened
daundered1294423daundered
davened124610073da_vened
degermed1335453d_egermed
degreed10258883degre_ed
diapered1238003diapered
dickered16117533dickered
differed1635523differed
digged104314653digg__ed
digger94616083digger__
diggers104413393digger_s
dithered13189293dithered
doddered1234943doddered
dogeared1145793dogeared
dogged106017703dogg__ed
dogger95216783dogger__
doggerels1252153doggerels
doggeries1246673doggeries
doggers104413433dogger_s
doggery13448263dogger_y
doggoned1243883doggoned
doggrel1033883dogg_rel
donnered10307753donnered
dormered1255673dormered
dowered122811553d_owered
dragged11379563dragg__ed
dragger10309173dragger__
draggers11357393dragger_s
draggled1254673dragg_led
eagerer8248823ea_gerer
endangered1343063endangered
fagged124717703fagg__ed
faggoted1443103faggoted
faltered122810983faltered
fathered151510433fathered
fingered13128333fingered
gagged104817153gagg__ed
gagger95016513gagger__
gaggers103413663gagger_s
gaggled11359913gagg_led
gandered112211173gandered
garnered10247113garnered
gartered10319583gartered
gathered13149373gathered
gingered11127743gingered
haggard13377183haggar_d
hagged124317703hagg__ed
haggled13359283hagg_led
haltered123112553haltered
hammered16218853hammered
hampered16239933hampered
hangared1337573hangared
hankered16289443hankered
havered144011453ha_vered
hungered13217053hungered
jabbered2034433jabbered
jagged164115353jagg__ed
jaggeder1842783jaggeder
jagger154016003jagger__
jaggeries18136973jaggeries
jaggers164012893jagger_s
jaggery19336903jagger_y
kashered1636403kashered
lackered15108673lackered
laddered1136743laddered
laggard10347623laggar_d
lagged95520133lagg__ed
lagger85919833lagger__
laggers94216243lagger_s
lappered13288213lappered
lathered121512323lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
leaguered1143223leaguered
lingered10129643lingered
mammered12237653mammered
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
mongered1238953mongered
nagged93916053nagg__ed
nagger84016123nagger__
naggers93812653nagger_s
nattered92011623nattered
paltered113012483paltered
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
pargeted1238683pargeted
pattered112714203pattered
paupered13216943paupered
raftered1237663raftered
ragged94620263ragg__ed
raggeder1143263raggeder
raggee84217603ragge_e_
raggees93710913ragge_es
ragweed1235073ragwe_ed
rapiered1136053rapiered
rogered939553_rogered
sabered103213023sa_bered
saggard10358953saggar_d
sagged94120013sagg__ed
sagger84321073sagger__
saggers94017083sagger_s
sniggered1243443sniggered
staggerer1143923staggerer
swaggerer1442943swaggerer
tabered103311593ta_bered
tagged93418123tagg__ed
tagger84017703tagger__
taggers93514193tagger_s
tampered13279463tampered
tapered102612933ta_pered
targeted1037483targeted
tattered92011443tattered
triggered1243523triggered
wafered14288433wa_fered
wagerer11328493wa_gerer
wagged124616123wagg__ed
wagger113616013wagger__
waggeries14127463waggeries
waggers124613083wagger_s
waggery15276903wagger_y
waggled13389363wagg_led
waggoned1443253waggoned
waitered1238753waitered
wandered132110793wandered
watered113014953wa_tered
wavered142910433wa_vered
yabbered1633963yabbered
yammered16225763yammered
yattered12239533yattered
zagged183612513zagg__ed

Search took 7 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 Limit1461621876.25023385.9
3Display Results1871870.0802337.5
 (SQL Overall)1786911876.73626527.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.