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

240 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
barterer10271163(None) 
banterer102811771banterer
bartered113113011bartered
barterers11269631barterers
batterer102713211batterer
alterer72713992_alterer
bantered113313632bantered
banterers112410002banterers
barbered13259542barbered
barrener1038332barrener
bartender1244602bartender
barter85525372bart__er
barters94223032barter_s
battener10369392battener
battered113315052battered
batterers113110712batterers
bitterer10309772bitterer
borderer1168102borderer
careerer1038582careerer
caterer92815942ca_terer
charterer14197322charterer
falterer11239852falterer
gartered10319582gartered
palterer102411272palterer
parterre1036982parterre
patterer103112172patterer
quarterer18145712quarterer
waterer103314072wa_terer
adherer1137573_adherer
altered83215733_altered
alterers82512493_alterers
armorer9259913_armorer
arteries8321483_arteries
artery9911453_arter_y
artier63419733_art_ier
artsier768943_artsier
austerer838383austerer
bacteria1248983bacteria
bacterin12410273bacterin
badgered1336213badgered
baiter84422553bait__er
baiters94619303baiter_s
bannered11299323bannered
banneret102412473banneret
banter84825333bant__er
banters94623113banter_s
baptizer2134893baptizer
barbecuer1593203barbecuer
barber104419323bar__ber
barberry1544863barberry
barbers114317503barber_s
barege94713543bar_ege_
bareges105212033bar_eges
barer74535803ba___rer
bargee94624443barge_e_
bargees105415873barge_es
bargemen1346403bargemen
barkeep1536363barke_ep
barkeeper1742933barkeeper
barker124822863bar__ker
barkers134318513barker_s
barkier133814483bar_kier
barmier114313043bar_mier
barnier93213673bar_nier
barometer13189043barometer
barrater10310143barrater
barre75929543bar__re_
barred95725793bar__red
barrel84517873bar__rel
barreled1137843barreled
barren85317613bar__ren
barres84427543bar__res
barret84930483bar__ret
barretor1046713barretor
barrier94017733bar_rier
bartend1038753barte_nd
bartended1344663bartended
bartenders1344223bartenders
bartends1136793bartends
bartering122313643bartering
barware12610703barware_
barwares13610093barwares
baster85333593bast__er
basters94930303baster_s
batcher144414853ba_tcher
bather115322513ba_t_her
battened11259573battened
batteners11238163batteners
batter84928873ba_t_ter
batterie10711533batterie
batteries11615113batteries
batters94626013batter_s
battery124911813batter_y
battier93515713ba_ttier
battler94113383ba_ttler
bergere1068913bergere_
bergeres1189113bergeres
berserker1543223berserker
bettered113011833bettered
bickerer16106773bickerer
bistered112913323bistered
bittered112711833bittered
blatherer14176713blatherer
blattered12198563blattered
blusterer11176293blusterer
bolsterer1145483bolsterer
bordered1248933bordered
borderers1276333borderers
brattier1047663brattier
breeder103210043b_reeder
brewer114812553b_r_ewer
briefer1235563b_riefer
burdener1136143burdener
burrer83718473bur__rer
buttered112712623buttered
butterier1177453butterier
cantered113415983cantered
caperer113013403ca_perer
capturer1246093capturer
careener1039323careener
career85822243car_e_er
careered1139493careered
careerers1137243careerers
carter84932273cart__er
carters95327253carter_s
catered103117773ca_tered
caterers102814403ca_terers
chartered15158393chartered
charterers15146053charterers
chatterer14196843chatterer
clatterer11186983clatterer
cratered1149683cratered
dapperer1335763dapperer
darkener1335993darkener
darneder1033983darneder
darter75320363dart__er
darters84017603darter_s
eagerer8248823ea_gerer
earthier1137443earthier
easterner945053easterner
enterer72015633_enterer
faltered122810983faltered
falterers12238033falterers
farther1348343fart_her
fastener11227833fastener
fattener11268113fattener
fetterer11207813fetterer
filterer11258143filterer
flatterer12187673flatterer
fosterer11239523fosterer
furtherer1543813furtherer
gardener1037103gardener
garnered10247113garnered
garter74420513gart__er
garters84218233garter_s
gatherer12147903gatherer
haltere103614703haltere_
haltered123112553haltered
halteres113414593halteres
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
harborer1348053harborer
hardener1238883hardener
harkener1537573harkener
hastener11259133hastener
heartener1256763heartener
jabberer1944023jabberer
larcener1036493larcener
latherer111310443latherer
letterer8259223letterer
litterer82810173litterer
loiterer837083loiterer
marketer1437383marketer
marrer83716673mar__rer
martyred1434283martyred
mastered112614003mastered
mattered112412903mattered
maturer938973ma_turer
miterer92511333_miterer
murderer1145263murderer
mutterer10218913mutterer
nattered92011623nattered
nurturer844473nurturer
orderer8127943_orderer
oysterer1136103oysterer
paltered113012483paltered
palterers11249533palterers
pamperer14228333pamperer
panderer112210913panderer
paperer113111903pa_perer
parcener1238473parcener
parleyer1335633parleyer
partaker1436873partaker
parterres1148053parterres
partier93520713part_ier
partner92811393part_ner
partnered1244483partnered
partyer12337873part_yer
pasturer1037523pasturer
pattered112714203pattered
patterers112410123patterers
pesterer102412703pesterer
pewterer13256313pewterer
plasterer1178103plasterer
portered112311543portered
potterer102310263potterer
putterer10209913putterer
quartered19155963quartered
quarterers19124823quarterers
raftered1237663raftered
rattener8238533rattener
saunterer945033saunterer
scatterer11186293scatterer
shatterer12177203shatterer
smatterer11185813smatterer
sorcerer1036433sorcerer
tamperer12248893tamperer
taperer92511793ta_perer
tartare73012683tartare_
tarter64023563tart__er
tartier74123263tart_ier
tattered92011443tattered
titterer8268523titterer
torturer835493torturer
totterer8217793totterer
utterer71910463_utterer
verderer1245373verderer
wagerer11328493wa_gerer
waitered1238753waitered
wanderer122210123wanderer
warrener1136913warrener
wartier103413913wart_ier
watered113014953wa_tered
waterers112312783wa_terers
waterier11312083wa_terier
waverer13319523wa_verer
winterer112110443winterer
yammerer15225483yammerer
yattered12239533yattered

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.406440125.6
2DLD Change Limit1461622407.34319904.9
3Display Results2402400.0932580.6
 (SQL Overall)1786912407.84222786.4
 
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.