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

171 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
badgered133621(None) 
adhered1239232_adhered
angered93013472_angered
badged114814792badg__ed
badger105415082badger__
badgerly1543282badgerly
badgers114812652badger_s
bannered11299322bannered
bantered113313652bantered
barbered13259552barbered
bartered113113032bartered
battered113315072battered
budgeted1344882budgeted
buggered1335622buggered
daggered12246402daggered
dangered11248512dangered
laagered1055852laagered
laddered1136742laddered
lagered92311152la_gered
saggered11237552saggered
wagered12299332wa_gered
adeemed1145393_adeemed
adhere10310333_adhere_
adherend1343863_adherend
adherer1137573_adherer
adheres11310163_adheres
adjured1634883_adjured
admired1135703_admired
adored84714243_ad_ored
adverted1336113_adverted
agreed84712503_a_greed
altered83215753_altered
angeled93211513_angeled
augured987193_augured
badassed1244273badassed
badder103817513badder__
badge94819693badg__e_
badgeless1343203badgeless
badgering1436973badgering
badges103917373badg__es
bagged114519903ba_g_ged
bagger104619203bagger__
baggers113915693bagger_s
banged104923733bang__ed
banger94423643banger__
bangers104020353banger_s
banneret102412473banneret
banterer102811783banterer
bared85144483ba___red
barged105822643barg__ed
bargee94624453barge_e_
bargees105415873barge_es
bargemen1346403bargemen
barred95725803ba__rred
barreled1137853barreled
barterer102711653barterer
basseted1136753basseted
battened11259573battened
batterer102713223batterer
beavered1437503beavered
bedewed1437153bed_ewed
beggared1334753beggared
bergere1068913bergere_
bergeres1189113bergeres
bettered113011843bettered
bickered17108003bickered
bistered112913333bistered
bittered112711833bittered
blabbered13184593blabbered
blathered15168363blathered
blattered12198583blattered
blazered2035063blazered
bogeyed1435673b_ogeyed
boogeyed1543723boogeyed
bordered1248933bordered
bothered142110393bothered
bowered133113043b_owered
brokered1536083brokered
budged114517243budg__ed
budger104617713budger__
budgers114314923budger_s
budgeter1244543budgeter
buffered1764993buffered
bumpered1536003bumpered
bunkered15177183bunkered
buttered112712633buttered
cadged114812343cadg__ed
cadger105013913cadger__
cadgers114712003cadger_s
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
cantered113415993cantered
capered123014043ca_pered
careered1139503careered
catered103117783ca_tered
cudgeled1343123cudgeled
dackered16116893dackered
daikered1495223daikered
dandered112110963dandered
doddered1234943doddered
eagerer8248823ea_gerer
fadged124712363fadg__ed
faltered122811003faltered
fathered151510433fathered
fidgeted1443893fidgeted
fingered13128333fingered
foddered1434553foddered
gandered112211173gandered
garnered10247123garnered
gartered10319603gartered
gathered13149383gathered
gingered11127743gingered
haltered123112573haltered
hammered16218853hammered
hampered16239933hampered
hangared1337573hangared
hankered16289443hankered
havered144011453ha_vered
hungered13217053hungered
jabbered2034433jabbered
jiggered1834203jiggered
juddered1833583juddered
kashered1636403kashered
kedgeree1444383kedgeree
lackered15108683lackered
ladened979053lad_ened
lappered13288213lappered
lathered121512333lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
lingered10129643lingered
maddened1334893maddened
mammered12237653mammered
mannered11249653mannered
mastered112614013mastered
mattered112412913mattered
mongered1238953mongered
nattered92011633nattered
ordered9108533ord_ered
paltered113012503paltered
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
pargeted1238683pargeted
pattered112714213pattered
paupered13216943paupered
raftered1237673raftered
rapiered1136053rapiered
rogered939553_rogered
sabered103213023sa_bered
saddened1135343saddened
saggared11326063saggared
staggered1244473staggered
swaggered1543193swaggered
tabered103311593ta_bered
tampered13279463tampered
tapered102612933ta_pered
targeted1037483targeted
tattered92011453tattered
teddered11255183teddered
wafered14288433wa_fered
wagerer11328493wa_gerer
waitered1238763waitered
wandered132110793wandered
watered113014963wa_tered
wavered142910433wa_vered
yabbered1633963yabbered
yammered16225763yammered
yattered12239543yattered

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.423422437.4
2DLD Change Limit1461621716.86021306.4
3Display Results1711710.0762250.0
 (SQL Overall)1786911717.35924282.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.