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

132 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
chatterer1419684(None) 
charterer14197331charterer
chattered15198001chattered
chatterers15205461chatterers
clatterer11186991clatterer
shatterer12177201shatterer
batterer102713222_batterer
caterer92815952c_a_terer
chafferer20133922chafferer
chamferer19154692chamferer
chaptered17176802chaptered
chartered15158402chartered
charterers15146052charterers
chastener1445702chastener
chatter124416642chatt__er
chatters134213952chatter_s
chattery16357272chatter_y
chattier1337512chatt_ier
chittered15166412chittered
clattered12178422clattered
clatterers12155422clatterers
flatterer12187682flatterer
patterer103112182_patterer
scatterer11186292scatterer
shattered13178212shattered
shatterers13185722shatterers
smatterer11185812smatterer
alterer72714013__alterer
banterer102811783_banterer
barterer102711653_barterer
battener10369403_battener
battered113315073_battered
batterers113110723_batterers
bitterer10309783_bitterer
blatherer14176723blatherer
blattered12198583blattered
cantered113415993c_antered
caperer113013403c_a_perer
capturer1246093c_apturer
careerer1038583c_areerer
catered103117783c_a_tered
caterers102814413c_a_terers
catheter1338153c_atheter
catteries11815553c_atteries
cattery123811603c_atter_y
cattier93317073c_att_ier
chaffered21154483chaffered
chafferers21153173chafferers
chambered19145993chambered
chamfered20165063chamfered
chamferers20153953chamferers
channeler1444603channeler
chanter123919733chant__er
chanters134016743chanter_s
chapter144213853chapt__er
chapteral1644703chapteral
chapters154012133chapter_s
charter123918303chart__er
charters134115593charter_s
chastened1545883chastened
chasteners1554803chasteners
chaster124718503chast__er
chastiser1444373chastiser
chatted133411893chatt__ed
chattel12388893chatt__el
chattels13286793chatte_ls
chatterbox2451533chatterbox
chattering16108643chattering
cheerer123511763ch__eerer
chitter124112963chitt__er
chitters133711173chitter_s
chuntered1536663chuntered
clamberer15185273clamberer
clatter94014973clatt__er
clatters103313913clatter_s
clattery13378193clatter_y
cluttered12185943cluttered
cottered112511743c_ottered
cratered1149693cra_tered
falterer11239873_falterer
fattener11268113_fattener
fetterer11207813_fetterer
flattener12175173flattener
flattered13188643flattered
flatterers13175913flatterers
flutterer12185263flutterer
fritterer12234403fritterer
gatherer12147913_gatherer
haltere103614713_haltere_
haltered123112573_haltered
halteres113414603_halteres
hammerer15278143_hammerer
hamperer15379093_hamperer
hankerer15248233_hankerer
hastener11259143_hastener
hatter94724873_hatt__er
hatteria1137883_hatteria
hatters104221523_hatter_s
latherer111310453_latherer
letterer8259223_letterer
litterer82810173_litterer
mattered112412913_mattered
mutterer10218913_mutterer
nattered92011633_nattered
palterer102411293_palterer
pattered112714213_pattered
patterers112410133_patterers
phatter123810203phatt__er
plasterer1178113plasterer
potterer102310263_potterer
putterer10209913_putterer
quarterer18145723quarterer
rattener8238533_rattener
scattered12197363scattered
scatterers12205043scatterers
shatter103615703shatt__er
shatters113313913shatter_s
shelterer1245043shelterer
shuttered13156333shuttered
smattered12186793smattered
smatterers12174873smatterers
spattered12187653spattered
sputterer11165263sputterer
stutterer9164913stutterer
tattered92011453_tattered
titterer8268523_titterer
totterer8217793_totterer
twitterer1243303twitterer
utterer71910463__utterer
waterer103314083_wa_terer
whatever1742673wha_tever
yattered12239543_yattered

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 Limit1486411327.67319372.0
3Display Results1321320.0632095.2
 (SQL Overall)1786911328.17221866.3
 
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.