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

190 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
batterers11311072(None) 
banterers112410011banterers
barterers11269641barterers
batteners11238181batteners
batterer102713221batterer_
patterers112410131patterers
alterers82512502_alterers
banterer102811782banterer_
barterer102711652barterer_
battener10369402battener_
battered113315072battere_d
batteries11615132batteries
batters94626022batt__ers
battlers104110972batt_lers
bitterer10309782bitterer_
blatherers15175342blatherers
caterers102814412ca_terers
chatterers15205462chatterers
clatterers12155422clatterers
falterers12238042falterers
fatteners12236882fatteners
fetterers12267042fetterers
flatterers13175912flatterers
gatherers13156892gatherers
latherers12158852latherers
letterers9228112letterers
litterers9228192litterers
mutterers11247372mutterers
palterers11249542palterers
patterer103112182patterer_
potterers11218662potterers
putterers11238362putterers
ratteners9237272ratteners
scatterers12205042scatterers
shatterers13185722shatterers
smatterers12174872smatterers
titterers9236992titterers
totterers9186812totterers
utterers8218652_utterers
waterers112312792wa_terers
adherers1296923_adherers
alterer72714013_alterer_
attempers13103503_attempers
attenders1045283_attenders
attesters935813_attesters
attires72312953_attire_s
bacterias1349303bacterias
bacterins13410653bacterins
baiters94619313bait__ers
bannerets11205463bannerets
bantered113313653bantere_d
banters94623123bant__ers
baptizers2243443baptizers
bartenders1344243bartenders
bartered113113033bartere_d
barters94223053bart__ers
basters94930313bast__ers
batchers153613273ba_tchers
bathers124720363ba_t_hers
battement1357773battement
battements1455813battements
battened11259573battene_d
battens95313263batt__ens
batter84928883batt__er_
batterie10711543batter_ie
battering122715153battering
battery124911823batt__ery
battier93515723batt_ier_
battiness11239843battiness
battler94113383batt_ler_
battles94517683batt_le_s
battues94610193batt_ue_s
bettered113011843bettere_d
betters94422093bett__ers
bickerers17115603bickerers
bittered112711833bittere_d
bitterest1147713bitterest
bitterness1245553bitterness
bitterns10428953bitter_ns
bitters94920363bitt__ers
blatherer14176723blatherer_
blattered12198583blattere_d
blatters104414093blatt__ers
blusterers12174993blusterers
bolsterers1244683bolsterers
borderers1276333borderers
bottlers103810013bott_lers
bottomers1344353bottomers
butcherers1742703butcherers
butterburs1443163butterburs
buttered112712633buttere_d
butterier1177463butterier_
butteries11711773butteries
butterless1244193butterless
butters94521723butt__ers
buttoners1145703buttoners
buttress1035883butt_ress
caperers122611723ca_perers
capturers1344633capturers
careerers1137243careerers
caterer92815953ca_terer_
cateress102311613ca_teress
catheters1437023catheters
catteries11815553catteries
charterers15146053charterers
chatterer14196843chatterer_
clatterer11186993clatterer_
ditherers13196683ditherers
dotterels1043903dotterels
easterners1044843easterners
enterers82214153_enterers
falterer11239873falterer_
fasteners12237063fasteners
fattener11268113fattener_
fetterer11207813fetterer_
filterers12206973filterers
flatteners13164153flatteners
flatterer12187683flatterer_
flutterers13184593flutterers
fosterers12238023fosterers
fritterers13203393fritterers
gatherer12147913gatherer_
halteres113414603haltere_s
hammerers16216563hammerers
hamperers16287533hamperers
hankerers16226713hankerers
hasteners12267823hasteners
hatterias1258763hatterias
hatters104221523hatt__ers
jabberers2043553jabberers
lateeners945573lateeners
latherer111310453latherer_
letterer8259223letterer_
litterer82810173litterer_
loiterers936263loiterers
mattered112412913mattere_d
matters94421753matt__ers
mattress1036533matt_ress
maturers1037383ma_turers
miterers10219683_miterers
mutterer10218913mutterer_
nattered92011633nattere_d
natters73718063natt__ers
oysterers1245573oysterers
palterer102411293palterer_
pamperers15236863pamperers
panderers12229153panderers
paperers122410453pa_perers
parterres1148083parterres
pasturers1136393pasturers
pattered112714213pattere_d
patterns10439943patter_ns
patters94825193patt__ers
pesterers112510463pesterers
pewterers14216043pewterers
plasterers1286123plasterers
potterer102310263potterer_
putterer10209913putterer_
quarterers19124833quarterers
ratteens8256053ratte_ens
rattener8238533rattener_
ratters74422473ratt__ers
rattlers83510293ratt_lers
saunterers1044383saunterers
scatterer11186293scatterer_
shatterer12177203shatterer_
smatterer11185813smatterer_
sputterers12174583sputterers
steerers82511353_steerers
stutterers10164303stutterers
tamperers13227313tamperers
taperers10269773ta_perers
tattered92011453tattere_d
tatters74520483tatt__ers
tattlers8369693tatt_lers
tattooers943633tattooers
titterer8268523titterer_
totterer8217793totterer_
twitterers1342673twitterers
utterer71910463_utterer_
wagerers12247613wa_gerers
wanderers13228483wanderers
waterer103314083wa_terer_
wattmeters1543613wattmeters
waverers14318613wa_verers
winterers12209723winterers
witherers15146843witherers
yammerers16214453yammerers
yattered12239543yattere_d
yatters103914623yatt__ers

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.436409841.7
2DLD Change Limit1486411907.62619491.3
3Display Results1901900.0762500.0
 (SQL Overall)1786911908.13821957.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.