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

197 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
blattered1219856(None) 
battered113315051b_attered
blathered15168351blathered
clattered12178401clattered
flattered13188621flattered
bantered113313632b_antered
bartered113113012b_artered
battened11259572b_attened
batterer102713212b_atterer
betattered1343142betattered
bettered113011832b_ettered
bittered112711832b_ittered
blabbered13184592blabbered
blatherer14176712blatherer
blatted104812712blatt__ed
blatter94415652blatter__
blatters104414092blatter_s
blazered2035062bla_zered
blethered15165432blethered
blistered12167682blistered
blithered15156122blithered
blustered12157262blustered
buttered112712622b_uttered
chattered15197992chattered
clatterer11186982clatterer
cluttered12185942cluttered
flattened13185302flattened
flatterer12187672flatterer
flittered13196252flittered
fluttered13185942fluttered
glittered11195402glittered
lathered121512322_lathered
lettered92910782_lettered
littered92511382_littered
mattered112412902_mattered
nattered92011622_nattered
pattered112714202_pattered
plastered1288892plastered
scattered12197352scattered
shattered13178202shattered
slathered13148542slathered
smattered12186782smattered
spattered12187642spattered
splattered13163932splattered
tattered92011442_tattered
yattered12239532_yattered
altered83215733__altered
attired8238913__attired
badgered1336213b_adgered
bannered11299323b_annered
banterer102811773b_anterer
barbered13259543b_arbered
barterer102711633b_arterer
batted95623653b_att__ed
battener10369393b_attener
batter84928873b_atter__
batterers113110713b_atterers
batterie10711533b_atterie
batteries11615113b_atteries
batters94626013b_atter_s
battery124911813b_atter_y
battled104213123b_att_led
beavered1437503bea_vered
bespattered1681723bespattered
bistered112913323b_istered
bitterer10309773b_itterer
blackened1845273blackened
blanketed1643913blanketed
blared95018243bla___red
blarneyed1542153blarneyed
blasted104213473blast__ed
blaster94017303blaster__
blasters104116143blaster_s
blather125314203blather__
blatherers15175343blatherers
blathers134713793blather_s
blattering13108713blattering
blinkered1644413blinkered
blotted103911833blott__ed
blotter94612853blotter__
blotters104110983blotter_s
blubbered13164113blubbered
blundered1335193blundered
blusterer11176293blusterer
bolstered1246093bolstered
bothered142110393b_othered
bratticed1443283bratticed
brattled11196723bratt_led
brothered1546003brothered
cantered113415983_cantered
catered103117773_ca_tered
chaptered17176793chaptered
chartered15158393chartered
chatterer14196843chatterer
chittered15166413chittered
clabbered16184763clabbered
clambered16146133clambered
clatter94014973clatter__
clatterers12155423clatterers
clatters103313913clatter_s
clattery13378193clatter_y
clavered14187633cla_vered
clustered12186613clustered
cottered112511733_cottered
cratered1149683cra_tered
elaterid948613ela_terid
faltered122810983_faltered
fathered151510433_fathered
fattened12268283_fattened
feathered16188893feathered
fettered12259493_fettered
flatted114012943flatt__ed
flattener12175173flattener
flatter103815963flatter__
flatterers13175913flatterers
flatteries1347413flatteries
flatters113814203flatter_s
flattery14338293flatter_y
flustered13185883flustered
flutterer12185263flutterer
frittered13205163frittered
gartered10319583_gartered
gathered13149373_gathered
gettered10258613_gettered
glaciered1343863glaciered
glandered1236333glandered
glistered11176293glistered
guttered10259163_guttered
haltered123112553_haltered
heathered16149463heathered
jittered16267223_jittered
laagered1055853_laagered
lackered15108673_lackered
laddered1136743_laddered
lagered92311153_la_gered
lappered13288213_lappered
latened8711923_la_tened
laterad8310843_la_terad
latherer111310443_latherer
latter65027893_latter__
latterly1136063_latterly
latticed1134793_latticed
laveered1235253_laveered
lawyered1534033_lawyered
layered11259413_la_yered
leathered13148713leathered
letterer8259223_letterer
litterer82810173_litterer
loitered938183_loitered
lustered92510603_lustered
mastered112614003_mastered
muttered112610793_muttered
paltered113012483_paltered
pattened11299393_pattened
patterer103112173_patterer
patterned1265743_patterned
plaistered1344133plaistered
plasterer1178103plasterer
platted103614263platt__ed
platter93917413platter__
platters103415283platter_s
pottered112311663_pottered
puttered112611143_puttered
quartered19155963quartered
raftered1237663_raftered
rattened9218623_rattened
realtered1037893realtered
relettered1144333relettered
reuttered1036073reuttered
scatterer11186293scatterer
scuttered12166423scuttered
shatterer12177203shatterer
shuttered13156333shuttered
skittered1434633skittered
slabbered14165083slabbered
slandered1137473slandered
slatted84015183slatt__ed
slattern837093slatter_n
slatterns935363slatterns
slavered12188033sla_vered
slithered13136623slithered
smatterer11185813smatterer
spluttered13153173spluttered
sputtered12166323sputtered
squattered2043253squattered
stuttered10145763stuttered
tittered9239493_tittered
tottered9208703_tottered
twittered1333813twittered
unaltered1037723unaltered
unattired1045083unattired
unlettered1143953unlettered
unuttered1065733unuttered
uttered82712433__uttered
waitered1238753_waitered
watered113014953_wa_tered
weathered16168513weathered

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411976.61022487.3
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.10925135.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.