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

168 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
barterers1126963(None) 
banterers112410001banterers
barterer102711631barterer_
batterers113110711batterers
alterers82512492_alterers
banterer102811772banterer_
bartenders1344222bartenders
bartered113113012bartere_d
barters94223032bart__ers
batteners11238162batteners
batterer102713212batterer_
borderers1276332borderers
careerers1137242careerers
caterers102814402ca_terers
charterers15146052charterers
falterers12238032falterers
palterers11249532palterers
parterres1148062parterres
patterers112410122patterers
quarterers19124822quarterers
waterers112312782wa_terers
adherers1296923_adherers
alterer72714003_alterer_
armorers10288973_armorers
arteries8321483_arteries
bacterias1349283bacterias
bacterins13410643bacterins
baiters94619303bait__ers
bannerets11205463bannerets
bantered113313633bantere_d
banters94623113bant__ers
baptizers2243443baptizers
barbecuers16112343barbecuers
barbered13259543barbere_d
barberry1544863barber_ry
barbers114317503bar__bers
bareges105212033bar_ege_s
bareness10912813bar_eness
bargees105415873barge_e_s
barkeepers1842893barkeepers
barkeeps1634143barke_eps
barkers134318513bar__kers
barometers14198513barometers
barraters1138043barraters
barrels94514363bar__rels
barrener1038333barrener_
barrens94414323bar__rens
barres84427543bar__re_s
barretors1146243barretors
barrets94917103bar__rets
barriers104311883bar_riers
bartender1244603bartender_
bartends1136793barte_nds
barter85525373bart__er_
bartering122313643bartering
barwares13610093barware_s
basters94930303bast__ers
batchers153613273ba_tchers
bathers124720363ba_t_hers
battener10369393battener_
battered113315053battere_d
batteries11615113batteries
batters94626013ba_t_ters
battlers104110973ba_ttlers
bergeres1189113bergere_s
berserkers1642953berserkers
bickerers17115593bickerers
bitterer10309773bitterer_
blatherers15175343blatherers
blusterers12174993blusterers
bolsterers1244683bolsterers
borderer1168103borderer_
breeders11368893b_reeders
brewers123811063b_r_ewers
briefers1335143b_riefers
burdeners1245063burdeners
burrers93814493bur__rers
caperers122611723ca_perers
capturers1344633capturers
careeners1138543careeners
careerer1038583careerer_
careers95218783car_e_ers
carters95327253cart__ers
caterer92815943ca_terer_
cateress102311613ca_teress
charterer14197323charterer_
chatterers15205463chatterers
clatterers12155423clatterers
darkeners1435153darkeners
darters84017603dart__ers
easterners1044823easterners
enterers82214153_enterers
falterer11239863falterer_
fasteners12237053fasteners
fatteners12236873fatteners
fetterers12267043fetterers
filterers12206973filterers
flatterers13175913flatterers
fosterers12238023fosterers
furtherers1643323furtherers
gardeners1136603gardeners
gartered10319593gartere_d
garters84218233gart__ers
gatherers13156883gatherers
halteres113414603haltere_s
hammerers16216563hammerers
hamperers16287533hamperers
hankerers16226713hankerers
harborers1446913harborers
hardeners1338083hardeners
harkeners1636073harkeners
hasteners12267813hasteners
hearteners1346213hearteners
jabberers2043553jabberers
larceners1135993larceners
latherers12158853latherers
letterers9228113letterers
litterers9228193litterers
loiterers936263loiterers
marketers1545983marketers
marrers93414313mar__rers
maturers1037383ma_turers
miterers10219683_miterers
murderers1244593murderers
mutterers11247373mutterers
nurturers943353nurturers
orderers9116563_orderers
oysterers1245573oysterers
palterer102411283palterer_
pamperers15236863pamperers
panderers12229153panderers
paperers122410453pa_perers
parceners1337453parceners
parleyers1444703parleyers
partakers1536563partakers
parterre1036993parter_re
partiers103514243part_iers
partners102711133part_ners
partyers13277763part_yers
pasturers1136393pasturers
patterer103112173patterer_
pesterers112510463pesterers
pewterers14216043pewterers
plasterers1286123plasterers
porteress1137933porteress
potterers11218663potterers
putterers11238363putterers
quarterer18145713quarterer_
ratteners9237263ratteners
saunterers1044383saunterers
scatterers12205043scatterers
shatterers13185723shatterers
smatterers12174873smatterers
sorcerers1145323sorcerers
tamperers13227313tamperers
taperers10269773ta_perers
titterers9236993titterers
torturers944343torturers
totterers9186813totterers
utterers8218653_utterers
verderers1344843verderers
wagerers12247613wa_gerers
wanderers13228483wanderers
warreners1236193warreners
waterer103314073wa_terer_
waverers14318613wa_verers
winterers12209723winterers
yammerers16214453yammerers

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411687.75019179.5
3Display Results1681680.0802100.0
 (SQL Overall)1786911688.25021659.5
 
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.