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

180 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
chattered1519799(None) 
chaptered17176791chaptered
chartered15158391chartered
chatterer14196841chatterer
chittered15166411chittered
clattered12178411clattered
shattered13178201shattered
battered113315052_battered
blattered12198572blattered
cantered113415982c_antered
catered103117772c_a_tered
chaffered21154482chaffered
chambered19145992chambered
chamfered20165062chamfered
charterer14197322charterer
chastened1545882chastened
chatted133411892chatt__ed
chatter124416642chatter__
chatterers15205462chatterers
chatters134213952chatter_s
chattery16357272chatter_y
chuntered1536662chuntered
clatterer11186992clatterer
cluttered12185942cluttered
cottered112511742c_ottered
cratered1149682cra_tered
flattered13188632flattered
haltered123112562_haltered
mattered112412902_mattered
nattered92011622_nattered
pattered112714202_pattered
scattered12197352scattered
shatterer12177202shatterer
shuttered13156332shuttered
smattered12186782smattered
spattered12187642spattered
tattered92011442_tattered
yattered12239532_yattered
altered83215743__altered
attired8238913__attired
bantered113313633_bantered
bartered113113013_bartered
battened11259573_battened
batterer102713213_batterer
betattered1343143betattered
bettered113011843_bettered
bittered112711833_bittered
blathered15168363blathered
buttered112712623_buttered
cambered15129003c_ambered
cancered132411553c_ancered
cankered153010223c_ankered
capered123014043c_a_pered
captured1336573c_aptured
careered1139493c_areered
caterer92815943c_a_terer
catted95422473c_att__ed
catteries11815533c_atteries
cattery123811603c_atter_y
centered112513523c_entered
chafferer20133923chafferer
chaired134211243cha__ired
chamferer19154693chamferer
channeled1544913channeled
chanted134015953chant__ed
chanter123919733chanter__
chanters134016743chanter_s
chapleted1743973chapleted
chapter144213853chapter__
chapteral1644703chapteral
chapters154012133chapter_s
charactered1952883charactered
chared125423693cha___red
charred134614493cha__rred
charted135116853chart__ed
charter123918303charter__
charterers15146053charterers
charters134115583charter_s
chastener1445703chastener
chaster124718503chaster__
chastised1554683chastised
chattel12388893chatt__el
chattels13286793chatte_ls
chatterbox2451533chatterbox
chattering16108643chattering
chattier1337513chatt_ier
checkered2144683checkered
cheered133713303ch__eered
chequered2442613chequered
chippered1945003chippered
chitter124112963chitter__
chitters133711173chitter_s
choppered1964883choppered
chowdered1944013chowdered
clabbered16184763clabbered
clambered16146133clambered
clatter94014973clatter__
clatterers12155423clatterers
clatters103313913clatter_s
clattery13378193clatter_y
clavered14187633cla_vered
clustered12186613clustered
coattend1134653coatte_nd
coattended1443103coattended
coattested1342983coattested
countered12313003countered
faltered122810993_faltered
fathered151510433_fathered
fattened12268283_fattened
feathered16188893feathered
fettered12259493_fettered
flattened13185303flattened
flatterer12187683flatterer
flittered13196253flittered
fluttered13185943fluttered
frittered13205163frittered
gartered10319593_gartered
gathered13149383_gathered
gettered10258613_gettered
glittered11195413glittered
guttered10259163_guttered
haltere103614713_haltere_
halteres113414603_halteres
hammered16218853_hammered
hampered16239933_hampered
hankered16289443_hankered
hastened12239103_hastened
hatred104814333_ha_t_red
hatted104921513_hatt__ed
hatter94724873_hatter__
hatteria1137863_hatteria
hatters104221523_hatter_s
havered144011453_ha_vered
heathered16149463heathered
jittered16267223_jittered
lathered121512333_lathered
leathered13148713leathered
lettered92910783_lettered
littered92511383_littered
mastered112614003_mastered
muttered112610793_muttered
paltered113012493_paltered
pattened11299393_pattened
patterer103112173_patterer
patterned1265743_patterned
phatter123810203phatter__
philtered1545493philtered
plastered1288903plastered
pottered112311663_pottered
puttered112611143_puttered
quartered19155963quartered
raftered1237663_raftered
rattened9218623_rattened
realtered1037893realtered
rechartered17153163rechartered
reuttered1036073reuttered
scatterer11186293scatterer
scuttered12166423scuttered
shatter103615703shatter__
shatterers13185723shatterers
shatters113313913shatter_s
sheltered1335583sheltered
skittered1434633skittered
slathered13148553slathered
smatterer11185813smatterer
splattered13163943splattered
sputtered12166323sputtered
squattered2043253squattered
stuttered10145763stuttered
tittered9239493_tittered
tottered9208703_tottered
twittered1333813twittered
unaltered1037723unaltered
unattired1045083unattired
unchartered1742833unchartered
unuttered1065733unuttered
uttered82712433__uttered
waitered1238753_waitered
watered113014953_wa_tered
weathered16168513weathered

Search took 7 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 Limit1486411806.43623095.2
3Display Results1801800.0762368.4
 (SQL Overall)1786911806.93525766.5
 
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.