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

280 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
batterer10271322(None) 
banterer102811781banterer
barterer102711651barterer
battener10369401battener
battered113315071battered
batterers113110721batterers
bitterer10309781bitterer
patterer103112181patterer
alterer72714012_alterer
bantered113313652bantered
banterers112410012banterers
bartered113113032bartered
barterers11269642barterers
battened11259572battened
batteners11238182batteners
batter84928882batt__er
batterie10711542batterie
batteries11615132batteries
batters94626022batter_s
battery124911822batter_y
battier93515722batt_ier
battler94113382batt_ler
bettered113011842bettered
bittered112711832bittered
blatherer14176722blatherer
blattered12198582blattered
buttered112712632buttered
butterier1177462butterier
caterer92815952ca_terer
chatterer14196842chatterer
clatterer11186992clatterer
falterer11239872falterer
fattener11268112fattener
fetterer11207812fetterer
flatterer12187682flatterer
gatherer12147912gatherer
latherer111310452latherer
letterer8259222letterer
litterer82810172litterer
mattered112412912mattered
mutterer10218912mutterer
nattered92011632nattered
palterer102411292palterer
pattered112714212pattered
patterers112410132patterers
potterer102310262potterer
putterer10209912putterer
rattener8238532rattener
scatterer11186292scatterer
shatterer12177202shatterer
smatterer11185812smatterer
tattered92011452tattered
titterer8268522titterer
totterer8217792totterer
utterer71910462_utterer
waterer103314082wa_terer
yattered12239542yattered
adherer1137573_adherer
altered83215753_altered
alterers82512503_alterers
attemper12103633_attemper
attender935913_attender
attester836503_attester
attire62412383_attire_
attired8238913_attired
attires72312953_attires
austerer838383austerer
bacteria1249003bacteria
bacterin12410283bacterin
badgered1336213badgered
baiter84422563bait__er
baiters94619313baiter_s
bannered11299323bannered
banneret102412473banneret
banter84825343bant__er
banters94623123banter_s
baptizer2134893baptizer
barbered13259553barbered
barer74535803ba___rer
barrener1038343barrener
bartender1244613bartender
barter85525383bart__er
barters94223053barter_s
baster85333603bast__er
basters94930313baster_s
batcher144414853ba_tcher
bather115322513ba_t_her
bathers124720363bather_s
batteau936353batte_au
batteaux1742513batteaux
batted95623653batt__ed
battement1357773battement
batten85217123batt__en
battens95313263batte_ns
battering122715153battering
battle85217863batt_le_
battled104213123batt_led
battlers104110973battler_s
battles94517683batt_les
battue84311003batt_ue_
battues94610193batt_ues
betattered1343143betattered
better84723703bett__er
betters94422093better_s
bickerer16106783bickerer
bistered112913333bistered
bitter84622673bitt__er
bitterest1147713bitterest
bitterly1335603bitterly
bittern94810683bitter_n
bitterns10428953bitterns
bitters94920363bitter_s
bittier94211663bitt_ier
blathered15168363blathered
blatherers15175343blatherers
blatter94415653blatt__er
blatters104414093blatter_s
blusterer11176293blusterer
bolsterer1145483bolsterer
borderer1168103borderer
bothered142110393bothered
bottler94211883bott_ler
bottomer1245103bottomer
brattier1047663bratt_ier
butcherer1643753butcherer
butter84724233butt__er
butterbur1342933butterbur
butteries11711773butteries
butters94521723butter_s
buttery124311193butter_y
buttoner1036973buttoner
cantered113415993cantered
caperer113013403ca_perer
capturer1246093capturer
careerer1038583careerer
catered103117783ca_tered
caterers102814413ca_terers
catheter1338153catheter
catteries11815553catteries
cattery123811603catter_y
cattier93317073catt_ier
charterer14197333charterer
chattered15198003chattered
chatterers15205463chatterers
clattered12178423clattered
clatterers12155423clatterers
cottered112511743cottered
dapperer1335763dapperer
ditherer12187763ditherer
dotterel945063dotterel
eagerer8248823ea_gerer
easterner945063easterner
enterer72015633_enterer
faltered122811003faltered
falterers12238043falterers
fastener11227843fastener
fathered151510433fathered
fattened12268283fattened
fatteners12236883fatteners
fatter94523213fatt__er
fattier103513463fatt_ier
fettered12259493fettered
fetterers12267043fetterers
filterer11258143filterer
flattener12175173flattener
flattered13188643flattered
flatterers13175913flatterers
flutterer12185263flutterer
fosterer11239523fosterer
fritterer12234403fritterer
gartered10319603gartered
gathered13149383gathered
gatherers13156893gatherers
gettered10258613gettered
guttered10259173guttered
haltere103614713haltere_
haltered123112573haltered
halteres113414603halteres
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
hastener11259143hastener
hatter94724873hatt__er
hatteria1137883hatteria
hatters104221523hatter_s
jabberer1944023jabberer
jittered16267223jittered
jitterier1644443jitterier
lateener835763lateener
lathered121512333lathered
latherers12158853latherers
latter65027893latt__er
latterly1136063latterly
lettered92910783lettered
letterers9228113letterers
littered92511383littered
litterers9228193litterers
loiterer837083loiterer
mastered112614013mastered
matter84325343matt__er
matters94421753matter_s
mattery123810713matter_y
maturer938983ma_turer
miterer92511333_miterer
muttered112610803muttered
mutterers11247373mutterers
natter64420743natt__er
natters73718063natter_s
nattier73614623natt_ier
oysterer1136103oysterer
paltered113012503paltered
palterers11249543palterers
pamperer14228333pamperer
panderer112210913panderer
paperer113111903pa_perer
parterre1037013parterre
pasturer1037523pasturer
pattee84323383patte_e_
pattened11299393pattened
patter84628263patt__er
pattern93712053patter_n
patterned1265753patterned
patterns10439943patterns
patters94825193patter_s
pesterer102412713pesterer
pewterer13256313pewterer
plasterer1178113plasterer
pottered112311663pottered
potterers11218663potterers
puttered112611153puttered
putterers11238363putterers
quarterer18145723quarterer
raftered1237673raftered
ratteen7329113ratte_en
rattened9218623rattened
ratteners9237273ratteners
ratter64326313ratt__er
ratters74422473ratter_s
rattier74015593ratt_ier
rattler74012743ratt_ler
rottener8216973rottener
saunterer945033saunterer
scattered12197363scattered
scatterers12205043scatterers
shattered13178213shattered
shatterers13185723shatterers
smattered12186793smattered
smatterers12174873smatterers
spattered12187653spattered
sputterer11165263sputterer
steerer73113633_steerer
stutterer9164913stutterer
tamperer12248893tamperer
taperer92511793ta_perer
tatter64024573tatt__er
tatters74520483tatter_s
tattier74216243tatt_ier
tattler73112213tatt_ler
tattooer844373tattooer
tittered9239493tittered
titterers9236993titterers
tottered9208703tottered
totterers9186813totterers
twitterer1243303twitterer
uttered82712443_uttered
utterers8218653_utterers
wagerer11328493wa_gerer
waitered1238763waitered
wanderer122210123wanderer
watered113014963wa_tered
waterers112312793wa_terers
waterier11312093wa_terier
watter93221983watt__er
wattmeter1443723wattmeter
waverer13319523wa_verer
winterer112110443winterer
witherer14187953witherer
yammerer15225483yammerer
yatter94116213yatt__er
yatters103914623yatter_s

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 Limit1461622807.64319123.6
3Display Results2802800.1102545.5
 (SQL Overall)1786912808.17321863.6
 
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.