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
barterer10271165(None) 
banterer102811781banterer
bartered113113031bartered
barterers11269641barterers
batterer102713221batterer
alterer72714012_alterer
bantered113313652bantered
banterers112410012banterers
barbered13259552barbered
barrener1038342barrener
bartender1244612bartender
barter85525382bart__er
barters94223052barter_s
battener10369402battener
battered113315072battered
batterers113110722batterers
bitterer10309782bitterer
borderer1168102borderer
careerer1038582careerer
caterer92815952ca_terer
charterer14197332charterer
falterer11239872falterer
gartered10319602gartered
palterer102411292palterer
parterre1037012parterre
patterer103112182patterer
quarterer18145722quarterer
waterer103314082wa_terer
adherer1137573_adherer
altered83215753_altered
alterers82512503_alterers
armorer9259913_armorer
arteries8321513_arteries
artery9911453_arter_y
artier63419733_art_ier
artsier768943_artsier
austerer838383austerer
bacteria1249003bacteria
bacterin12410283bacterin
badgered1336213badgered
baiter84422563bait__er
baiters94619313baiter_s
bannered11299323bannered
banneret102412473banneret
banter84825343bant__er
banters94623123banter_s
baptizer2134893baptizer
barbecuer1593203barbecuer
barber104419323bar__ber
barberry1544873barberry
barbers114317503barber_s
barege94713543bar_ege_
bareges105212033bar_eges
barer74535803ba___rer
bargee94624453barge_e_
bargees105415873barge_es
bargemen1346403bargemen
barkeep1536363barke_ep
barkeeper1742933barkeeper
barker124822863bar__ker
barkers134318513barker_s
barkier133814483bar_kier
barmier114313043bar_mier
barnier93213673bar_nier
barometer13189043barometer
barrater10310153barrater
barre75929553bar__re_
barred95725803bar__red
barrel84517883bar__rel
barreled1137853barreled
barren85317623bar__ren
barres84427553bar__res
barret84930493bar__ret
barretor1046713barretor
barrier94017753bar_rier
bartend1038753barte_nd
bartended1344673bartended
bartenders1344243bartenders
bartends1136793bartends
bartering122313653bartering
barware12610703barware_
barwares13610093barwares
baster85333603bast__er
basters94930313baster_s
batcher144414853ba_tcher
bather115322513ba_t_her
battened11259573battened
batteners11238183batteners
batter84928883ba_t_ter
batterie10711543batterie
batteries11615133batteries
batters94626023batter_s
battery124911823batter_y
battier93515723ba_ttier
battler94113383ba_ttler
bergere1068913bergere_
bergeres1189113bergeres
berserker1543233berserker
bettered113011843bettered
bickerer16106783bickerer
bistered112913333bistered
bittered112711833bittered
blatherer14176723blatherer
blattered12198583blattered
blusterer11176293blusterer
bolsterer1145483bolsterer
bordered1248933bordered
borderers1276333borderers
brattier1047663brattier
breeder103210043b_reeder
brewer114812553b_r_ewer
briefer1235563b_riefer
burdener1136143burdener
burrer83718473bur__rer
buttered112712633buttered
butterier1177463butterier
cantered113415993cantered
caperer113013403ca_perer
capturer1246093capturer
careener1039333careener
career85822243car_e_er
careered1139503careered
careerers1137243careerers
carter84932273cart__er
carters95327263carter_s
catered103117783ca_tered
caterers102814413ca_terers
chartered15158403chartered
charterers15146053charterers
chatterer14196843chatterer
clatterer11186993clatterer
cratered1149693cratered
dapperer1335763dapperer
darkener1335993darkener
darneder1033983darneder
darter75320363dart__er
darters84017613darter_s
eagerer8248823ea_gerer
earthier1137443earthier
easterner945063easterner
enterer72015633_enterer
faltered122811003faltered
falterers12238043falterers
farther1348343fart_her
fastener11227843fastener
fattener11268113fattener
fetterer11207813fetterer
filterer11258143filterer
flatterer12187683flatterer
fosterer11239523fosterer
furtherer1543813furtherer
gardener1037113gardener
garnered10247123garnered
garter74420513gart__er
garters84218253garter_s
gatherer12147913gatherer
haltere103614713haltere_
haltered123112573haltered
halteres113414603halteres
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
harborer1348063harborer
hardener1238883hardener
harkener1537573harkener
hastener11259143hastener
heartener1256773heartener
jabberer1944023jabberer
larcener1036493larcener
latherer111310453latherer
letterer8259223letterer
litterer82810173litterer
loiterer837083loiterer
marketer1437383marketer
marrer83716673mar__rer
martyred1434293martyred
mastered112614013mastered
mattered112412913mattered
maturer938983ma_turer
miterer92511333_miterer
murderer1145263murderer
mutterer10218913mutterer
nattered92011633nattered
nurturer844473nurturer
orderer8127943_orderer
oysterer1136103oysterer
paltered113012503paltered
palterers11249543palterers
pamperer14228333pamperer
panderer112210913panderer
paperer113111903pa_perer
parcener1238473parcener
parleyer1335633parleyer
partaker1436873partaker
parterres1148083parterres
partier93520713part_ier
partner92811393part_ner
partnered1244493partnered
partyer12337873part_yer
pasturer1037523pasturer
pattered112714213pattered
patterers112410133patterers
pesterer102412713pesterer
pewterer13256313pewterer
plasterer1178113plasterer
portered112311553portered
potterer102310263potterer
putterer10209913putterer
quartered19155973quartered
quarterers19124833quarterers
raftered1237673raftered
rattener8238533rattener
saunterer945033saunterer
scatterer11186293scatterer
shatterer12177203shatterer
smatterer11185813smatterer
sorcerer1036433sorcerer
tamperer12248893tamperer
taperer92511793ta_perer
tartare73012683tartare_
tarter64023563tart__er
tartier74123263tart_ier
tattered92011453tattered
titterer8268523titterer
torturer835493torturer
totterer8217793totterer
utterer71910463_utterer
verderer1245373verderer
wagerer11328493wa_gerer
waitered1238763waitered
wanderer122210123wanderer
warrener1136923warrener
wartier103413913wart_ier
watered113014963wa_tered
waterers112312793wa_terers
waterier11312093wa_terier
waverer13319523wa_verer
winterer112110443winterer
yammerer15225483yammerer
yattered12239543yattered

Search took 10 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 Limit1461622409.01616211.4
3Display Results2402400.1102181.8
 (SQL Overall)1786912409.54618718.9
 
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.