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
batterer10271321(None) 
banterer102811771banterer
barterer102711631barterer
battener10369391battener
battered113315051battered
batterers113110711batterers
bitterer10309771bitterer
patterer103112171patterer
alterer72713992_alterer
bantered113313632bantered
banterers112410002banterers
bartered113113012bartered
barterers11269632barterers
battened11259572battened
batteners11238162batteners
batter84928872batt__er
batterie10711532batterie
batteries11615112batteries
batters94626012batter_s
battery124911812batter_y
battier93515712batt_ier
battler94113382batt_ler
bettered113011832bettered
bittered112711832bittered
blatherer14176712blatherer
blattered12198562blattered
buttered112712622buttered
butterier1177452butterier
caterer92815942ca_terer
chatterer14196842chatterer
clatterer11186982clatterer
falterer11239852falterer
fattener11268112fattener
fetterer11207812fetterer
flatterer12187672flatterer
gatherer12147902gatherer
latherer111310442latherer
letterer8259222letterer
litterer82810172litterer
mattered112412902mattered
mutterer10218912mutterer
nattered92011622nattered
palterer102411272palterer
pattered112714202pattered
patterers112410122patterers
potterer102310262potterer
putterer10209912putterer
rattener8238532rattener
scatterer11186292scatterer
shatterer12177202shatterer
smatterer11185812smatterer
tattered92011442tattered
titterer8268522titterer
totterer8217792totterer
utterer71910462_utterer
waterer103314072wa_terer
yattered12239532yattered
adherer1137573_adherer
altered83215733_altered
alterers82512493_alterers
attemper12103633_attemper
attender935913_attender
attester836503_attester
attire62412383_attire_
attired8238913_attired
attires72312953_attires
austerer838383austerer
bacteria1248983bacteria
bacterin12410273bacterin
badgered1336213badgered
baiter84422553bait__er
baiters94619303baiter_s
bannered11299323bannered
banneret102412473banneret
banter84825333bant__er
banters94623113banter_s
baptizer2134893baptizer
barbered13259543barbered
barer74535803ba___rer
barrener1038333barrener
bartender1244603bartender
barter85525373bart__er
barters94223033barter_s
baster85333593bast__er
basters94930303baster_s
batcher144414853ba_tcher
bather115322513ba_t_her
bathers124720363bather_s
batteau936343batte_au
batteaux1742503batteaux
batted95623653batt__ed
battement1357773battement
batten85217123batt__en
battens95313263batte_ns
battering122715143battering
battle85217863batt_le_
battled104213123batt_led
battlers104110973battler_s
battles94517683batt_les
battue84311003batt_ue_
battues94610193batt_ues
betattered1343143betattered
better84723703bett__er
betters94422093better_s
bickerer16106773bickerer
bistered112913323bistered
bitter84622673bitt__er
bitterest1147713bitterest
bitterly1335603bitterly
bittern94810683bitter_n
bitterns10428953bitterns
bitters94920363bitter_s
bittier94211663bitt_ier
blathered15168353blathered
blatherers15175343blatherers
blatter94415653blatt__er
blatters104414093blatter_s
blusterer11176293blusterer
bolsterer1145483bolsterer
borderer1168103borderer
bothered142110393bothered
bottler94211883bott_ler
bottomer1245103bottomer
brattier1047663bratt_ier
butcherer1643753butcherer
butter84724233butt__er
butterbur1342923butterbur
butteries11711763butteries
butters94521723butter_s
buttery124311193butter_y
buttoner1036973buttoner
cantered113415983cantered
caperer113013403ca_perer
capturer1246093capturer
careerer1038583careerer
catered103117773ca_tered
caterers102814403ca_terers
catheter1338153catheter
catteries11815523catteries
cattery123811603catter_y
cattier93317073catt_ier
charterer14197323charterer
chattered15197993chattered
chatterers15205463chatterers
clattered12178403clattered
clatterers12155423clatterers
cottered112511733cottered
dapperer1335763dapperer
ditherer12187763ditherer
dotterel945063dotterel
eagerer8248823ea_gerer
easterner945053easterner
enterer72015633_enterer
faltered122810983faltered
falterers12238033falterers
fastener11227833fastener
fathered151510433fathered
fattened12268283fattened
fatteners12236873fatteners
fatter94523213fatt__er
fattier103513463fatt_ier
fettered12259493fettered
fetterers12267043fetterers
filterer11258143filterer
flattener12175173flattener
flattered13188623flattered
flatterers13175913flatterers
flutterer12185263flutterer
fosterer11239523fosterer
fritterer12234403fritterer
gartered10319583gartered
gathered13149373gathered
gatherers13156883gatherers
gettered10258613gettered
guttered10259163guttered
haltere103614703haltere_
haltered123112553haltered
halteres113414593halteres
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
hastener11259133hastener
hatter94724873hatt__er
hatteria1137863hatteria
hatters104221523hatter_s
jabberer1944023jabberer
jittered16267223jittered
jitterier1644433jitterier
lateener835763lateener
lathered121512323lathered
latherers12158853latherers
latter65027893latt__er
latterly1136063latterly
lettered92910783lettered
letterers9228113letterers
littered92511383littered
litterers9228193litterers
loiterer837083loiterer
mastered112614003mastered
matter84325343matt__er
matters94421753matter_s
mattery123810713matter_y
maturer938973ma_turer
miterer92511333_miterer
muttered112610793muttered
mutterers11247373mutterers
natter64420743natt__er
natters73718063natter_s
nattier73614623natt_ier
oysterer1136103oysterer
paltered113012483paltered
palterers11249533palterers
pamperer14228333pamperer
panderer112210913panderer
paperer113111903pa_perer
parterre1036983parterre
pasturer1037523pasturer
pattee84323383patte_e_
pattened11299393pattened
patter84628263patt__er
pattern93712053patter_n
patterned1265743patterned
patterns10439943patterns
patters94825193patter_s
pesterer102412703pesterer
pewterer13256313pewterer
plasterer1178103plasterer
pottered112311663pottered
potterers11218663potterers
puttered112611143puttered
putterers11238363putterers
quarterer18145713quarterer
raftered1237663raftered
ratteen7329113ratte_en
rattened9218623rattened
ratteners9237263ratteners
ratter64326313ratt__er
ratters74422473ratter_s
rattier74015593ratt_ier
rattler74012743ratt_ler
rottener8216973rottener
saunterer945033saunterer
scattered12197353scattered
scatterers12205043scatterers
shattered13178203shattered
shatterers13185723shatterers
smattered12186783smattered
smatterers12174873smatterers
spattered12187643spattered
sputterer11165263sputterer
steerer73113633_steerer
stutterer9164913stutterer
tamperer12248893tamperer
taperer92511793ta_perer
tatter64024573tatt__er
tatters74520483tatter_s
tattier74216243tatt_ier
tattler73112213tatt_ler
tattooer844373tattooer
tittered9239493tittered
titterers9236993titterers
tottered9208703tottered
totterers9186813totterers
twitterer1243303twitterer
uttered82712433_uttered
utterers8218653_utterers
wagerer11328493wa_gerer
waitered1238753waitered
wanderer122210123wanderer
watered113014953wa_tered
waterers112312783wa_terers
waterier11312083wa_terier
watter93221983watt__er
wattmeter1443723wattmeter
waverer13319523wa_verer
winterer112110443winterer
witherer14187953witherer
yammerer15225483yammerer
yatter94116213yatt__er
yatters103914623yatter_s

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.1561145455.1
2DLD Change Limit1461622807.70318974.7
3Display Results2802800.1232276.4
 (SQL Overall)1786912807.98222386.7
 
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.