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

341 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
bartered11311303(None) 
bantered113313651bantered
barbered13259551barbered
barterer102711651barterer
battered113315071battered
gartered10319601gartered
altered83215752_altered
badgered1336212badgered
bannered11299322bannered
banterer102811782banterer
barred95725802bar__red
barreled1137852barreled
bartend1038752barte_nd
bartended1344672bartended
barter85525382barter__
barterers11269642barterers
barters94223052barter_s
battened11259572battened
batterer102713222batterer
bettered113011842bettered
bistered112913332bistered
bittered112711832bittered
blattered12198582blattered
bordered1248932bordered
buttered112712632buttered
cantered113415992cantered
careered1139502careered
catered103117782ca_tered
chartered15158402chartered
cratered1149692cratered
faltered122811002faltered
garnered10247122garnered
haltered123112572haltered
martyred1434292martyred
mastered112614012mastered
mattered112412912mattered
nattered92011632nattered
paltered113012502paltered
partnered1244492partnered
pattered112714212pattered
portered112311552portered
quartered19155972quartered
raftered1237672raftered
tattered92011452tattered
waitered1238762waitered
watered113014962wa_tered
yattered12239542yattered
absterged1353353absterged
adhered1239233_adhered
alterer72714013_alterer
angered93013473_angered
anteed75616113_ante_ed
antired82316193_antired
antlered938263_antlered
arbored103811603_arbored
armored102610473_armored
arteries8321513_arteries
artery9911453_arter_y
attired8238913_attired
bacteria1249003bacteria
bacterin12410283bacterin
bacterized2446313bacterized
bacteroid1456273bacteroid
baited95319243bait__ed
baiter84422563baiter__
baiters94619313baiter_s
banistered1394623banistered
banneret102412473banneret
banter84825343banter__
banterers112410013banterers
banters94623123banter_s
baptised1335263baptised
baptized2245483baptized
barbecued16113293barbecued
barbed115121313bar__bed
barbequed23122703barbequed
barber104419323barber__
barberry1544873barberry
barbers114317503barber_s
barded105426423bar__ded
bared85144483ba___red
barege94713543bar_ege_
bareges105212033bar_eges
barehead1446603bar_ehead
barer74535803bar_er__
barfed125416383bar__fed
barged105822643bar__ged
bargee94624453barge_e_
bargees105415873barge_es
bargemen1346403bargemen
barked135027313bar__ked
barkeep1536363barke_ep
barker124822863barker__
barkers134318513barker_s
barned95623583bar__ned
barraged1297703barraged
barre75929553bar__re_
barrel84517883bar__rel
barrelled1245263barrelled
barren85317623bar__ren
barrener1038343barrener
barres84427553bar__res
barret84930493bar__ret
bartender1244613bartender
bartends1136793bartends
bartering122313653bartering
barware12610703barware_
barwares13610093barwares
basseted1136753basseted
bastard103012423bastar_d
basted95227233bast__ed
baster85333603baster__
basters94930313baster_s
batched154114243ba_tched
bated85935533ba_t__ed
bathed125518743ba_t_hed
batiked1435963ba_tiked
batted95623653ba_t_ted
battener10369403battener
batter84928883batter__
batterers113110723batterers
batterie10711543batterie
batteries11615133batteries
batters94626023batter_s
battery124911823batter_y
battled104213123ba_ttled
beavered1437503beavered
bergere1068913bergere_
bergeres1189113bergeres
berthed13259123bert_hed
betattered1343143betattered
bickered17108003bickered
birred94713203bir__red
birthed13228593birt_hed
bistred103311853bist_red
bitterer10309783bitterer
blabbered13184593blabbered
blarneyed1542153blarneyed
blathered15168363blathered
blazered2035063blazered
blethered15165433blethered
blistered12167683blistered
blithered15156123blithered
blustered12157263blustered
bolstered1246093bolstered
borderer1168103borderer
bothered142110393bothered
bowered133113043b_owered
brattled11196723brattled
brazened20134903brazened
breed85526693b_r_e_ed
breezed19287053b_reezed
brewed125411873b_r_ewed
briefed1335743b_riefed
brokered1536083brokered
brothered1546003brothered
buffered1764993buffered
buggered1335623buggered
bumpered1536003bumpered
bunkered15177183bunkered
burdened1236423burdened
burred95820723bur__red
burseed1049503burse_ed
burthened1543963burthened
burweed1347823burwe_ed
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
capered123014043ca_pered
captured1336573captured
careened1139193careened
careerer1038583careerer
carpeted1338953carpeted
carted98631443cart__ed
carter84932273carter__
carters95327263carter_s
cartoned111312833cartoned
caterer92815953ca_terer
centered112513523centered
chaptered17176803chaptered
charterer14197333charterer
chattered15198003chattered
clattered12178423clattered
cornered11311133cornered
cottered112511743cottered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
darkened1435943darkened
darted84620923dart__ed
darter75320363darter__
darters84017613darter_s
dartled9409853dart_led
dormered1255673dormered
earthed1139923eart_hed
entered82718883_entered
factored1436233factored
falterer11239873falterer
farted105121783fart__ed
fastened12257853fastened
fathered151510433fathered
fattened12268283fattened
festered122512113festered
fettered12259493fettered
filtered12259043filtered
flattered13188643flattered
fostered122210453fostered
furthered1644483furthered
gandered112211173gandered
gardened1137003gardened
garred85217413gar__red
garreted1057523garreted
garter74420513garter__
garters84218253garter_s
gathered13149383gathered
gettered10258613gettered
guttered10259173guttered
haltere103614713haltere_
halteres113414603halteres
hammered16218853hammered
hampered16239933hampered
hankered16289443hankered
harbored1438643harbored
hardened1338613hardened
harkened1637483harkened
hastened12239103hastened
hatred104814333ha_t_red
havered144011453ha_vered
heartened1347083heartened
jabbered2034433jabbered
jarred144613253jar__red
jittered16267223jittered
kashered1636403kashered
laagered1055853laagered
lackered15108683lackered
laddered1136743laddered
lagered92311153la_gered
lappered13288213lappered
latened8711923la_tened
laterad8310853la_terad
lathered121512333lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
lettered92910783lettered
littered92511383littered
loitered938183loitered
lustered92510613lustered
mammered12237653mammered
mannered11249653mannered
marketed1537323marketed
marred95421043mar__red
marted94425213mart__ed
marveled1436433marveled
matured10310043ma_tured
metered103514013_metered
mitered103213233_mitered
mortared1137213mortared
murdered1236033murdered
murthered1544483murthered
mustered112511513mustered
muttered112610803muttered
natured838963na_tured
neutered937423neutered
nurtured935263nurtured
ordered9108533_ordered
oystered1236923oystered
palterer102411293palterer
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
parceled1338343parceled
pargeted1238683pargeted
parleyed1436243parleyed
parred95024073par__red
parted94228683part__ed
parterre1037013parterre
parterres1148083parterres
partied103516553part_ied
pastored1139973pastored
pastured1138233pastured
pattened11299393pattened
patterer103112183patterer
patterned1265753patterned
paupered13216943paupered
peltered112510453peltered
pestered112814973pestered
petered103314973_petered
plastered1288913plastered
pottered112311663pottered
puttered112611153puttered
quarterer18145723quarterer
rapiered1136053rapiered
raptured1155473raptured
rattened9218623rattened
realtered1037903realtered
sabered103213023sa_bered
saggered11237553saggered
sauntered1036293sauntered
sauteed8349613saute_ed
scarpered1435123scarpered
scattered12197363scattered
shattered13178213shattered
sintered92213903sintered
sistered92612803sistered
smartened1244273smartened
smattered12186793smattered
spattered12187653spattered
tabered103311593ta_bered
tampered13279463tampered
tapered102612933ta_pered
targeted1037483targeted
tarred74720283tar__red
tartare73012683tartare_
tarted74923373tart__ed
tarter64023563tarter__
tarweed1137343tarwe_ed
tautened935423tautened
teetered9258303teetered
tentered96412103tentered
tittered9239493tittered
tortured935843tortured
tottered9208703tottered
unaltered1037733unaltered
unbarbered1542883unbarbered
uttered82712443_uttered
wafered14288433wa_fered
wagered12299333wa_gered
wandered132110793wandered
warred104019853war__red
warted104223233wart__ed
waterbed1436453wa_terbed
waterer103314083wa_terer
wavered142910433wa_vered
weltered12238443weltered
westered122511873westered
wintered122111573wintered
yabbered1633963yabbered
yammered16225763yammered

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 Limit1461623416.75021653.6
3Display Results3413410.1402435.7
 (SQL Overall)1786913417.31324434.7
 
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.