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

261 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
barbered1325954(None) 
bartered113113011bartered
arbored103811602_arbored
badgered1336212badgered
bannered11299322bannered
bantered113313632bantered
barbecued16113292barbecued
barbed115121312barb__ed
barbequed23122702barbequed
barber104419322barber__
barberry1544862barberry
barbers114317502barber_s
barred95725802bar__red
barreled1137852barreled
barterer102711632barterer
battered113315052battered
blabbered13184592blabbered
bordered1248932bordered
cambered15129002cambered
careered1139492careered
garnered10247112garnered
gartered10319592gartered
harbored1438642harbored
jabbered2034432jabbered
sabered103213022sa_bered
tabered103311592ta_bered
unbarbered1542882unbarbered
yabbered1633962yabbered
adhered1239233_adhered
altered83215743_altered
angered93013473_angered
arbores94016033_arbores
arboured1156253_arboured
armored102610473_armored
babbled113612863ba_bbled
babied114913513ba_b_ied
banneret102412473banneret
banterer102811773banterer
barbaric1446373barbaric
barbarized2444853barbarized
barbate11314543barbate_
barbe95328283barb__e_
barbecue14194703barbecue
barbecuer1593203barbecuer
barbecues15144473barbecues
barbel104317073barb__el
barbell11429963barbe_ll
barbells12368823barbells
barbels114514433barbe_ls
barbeque21134063barbeque
barbeques22103873barbeques
barbering14229683barbering
barberries1446233barberries
barbes104526233barb__es
barbet104427883barb__et
barbets114915843barbe_ts
barbette1249113barbette
barbettes1348163barbettes
barbicel14144963barbicel
barbie105018353barb_ie_
barbies114519593barb_ies
barbule1137943barbule_
barbules1238043barbules
barbwire1543863barbwire_
barbwires1643643barbwires
barded105426423bar__ded
bareboned1445103bareboned
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
barraged1297693barraged
barre75929553bar__re_
barrel84517883bar__rel
barrelled1245263barrelled
barren85317623bar__ren
barrener1038343barrener
barres84427553bar__res
barret84930493bar__ret
bartend1038753barte_nd
bartended1344663bartended
barter85525373barter__
barterers11269633barterers
barters94223033barter_s
barware12610703barware_
barwares13610093barwares
basseted1136753basseted
battened11259573battened
batterer102713213batterer
baubee103215993baube_e_
baubees11348713baube_es
bawbee132714233bawbe_e_
bawbees14337243bawbe_es
bayberry1842963bayberry
bearberry1642633bearberry
beavered1437503beavered
berberin1246563berberin
berberis1246603berberis
bergere1068913bergere_
bergeres1189113bergeres
bettered113011843bettered
bickered17108003bickered
birred94713203bir__red
bistered112913333bistered
bittered112711833bittered
blarneyed1542153blarneyed
blathered15168363blathered
blattered12198573blattered
blazered2035063blazered
blubbered13164113blubbered
borderer1168103borderer
bothered142110393bothered
bowered133113043b_owered
brabbled12337633brabbled
brazened20134903brazened
breed85526693b_r_e_ed
breezed19287053b_reezed
brewed125411873b_r_ewed
briefed1335743b_riefed
brokered1536083brokered
buffered1764993buffered
buggered1335623buggered
bumpered1536003bumpered
bunkered15177183bunkered
burbled124312673burb_led
burdened1236423burdened
burred95820723bur__red
burseed1049503burse_ed
burweed1347823burwe_ed
buttered112712623buttered
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043ca_pered
carboyed1637183carboyed
carburet12411113carburet
careened1139193careened
careerer1038583careerer
carpeted1338953carpeted
catered103117773ca_tered
chambered19145993chambered
chartered15158393chartered
clabbered16184763clabbered
clambered16146133clambered
corbeled1338373corbeled
cornered11311133cornered
cratered1149683cratered
cumbered15157963cumbered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
darkened1435943darkened
dormered1255673dormered
faltered122810993faltered
fathered151510433fathered
fibered1337643_fibered
gandered112211173gandered
garbed104815663garb__ed
garbled114512803garb_led
gardened1137003gardened
garred85217413gar__red
garreted1057523garreted
gathered13149383gathered
gibbered1444303gibbered
halberd1336053halber_d
haltered123112563haltered
hammered16218853hammered
hampered16239933hampered
hankered16289443hankered
harborer1348063harborer
harboured1544313harboured
hardened1338613hardened
harkened1637483harkened
havered144011453ha_vered
jabberer1944023jabberer
jarred144613253jar__red
kashered1636403kashered
laagered1055853laagered
labeled102510563la_beled
labored102810253la_bored
lackered15108683lackered
laddered1136743laddered
lagered92311153la_gered
lappered13288213lappered
lathered121512333lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
limbered13158123limbered
lumbered13188233lumbered
mammered12237653mammered
mannered11249653mannered
marbled123212113marb_led
marketed1537323marketed
marred95421043mar__red
martyred1434283martyred
marveled1436433marveled
mastered112614003mastered
mattered112412903mattered
membered1535903membered
murdered1236023murdered
nattered92011623nattered
numbered13147143numbered
ordered9108533_ordered
paltered113012493paltered
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
parbaked1735503parbaked
parceled1338343parceled
pargeted1238683pargeted
parleyed1436243parleyed
parred95024073par__red
partnered1244483partnered
pattered112714203pattered
paupered13216943paupered
portered112311543portered
purebred1344253purebred
quartered19155963quartered
rabbeted1334443rabbeted
raftered1237663raftered
rapiered1136053rapiered
rebred95816353__rebred
rubbered1335383rubbered
sabred95916533sa_b_red
saggered11237553saggered
scarpered1435113scarpered
slabbered14165083slabbered
sobered102912433_sobered
tabored102810563ta_bored
tampered13279463tampered
tapered102612933ta_pered
targeted1037483targeted
tarred74720283tar__red
tarweed1137343tarwe_ed
tattered92011443tattered
timbered13137383timbered
umbered121510113_umbered
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wandered132110793wandered
warbled133212163warb_led
warred104019853war__red
watered113014953wa_tered
wavered142910433wa_vered
yammered16225763yammered
yattered12239533yattered

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.420425454.8
2DLD Change Limit1461622618.36017483.5
3Display Results2612610.1102372.7
 (SQL Overall)1786912618.89020100.2
 
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.