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

137 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
clatterer1118699(None) 
chatterer14196841chatterer
clattered12178421clattered
clatterers12155421clatterers
flatterer12187681flatterer
batterer102713222_batterer
blatherer14176722blatherer
blattered12198582blattered
caterer92815952c_a_terer
charterer14197332charterer
chattered15198002chattered
chatterers15205462chatterers
clamberer15185272clamberer
clatter94014972clatt__er
clatters103313912clatter_s
clattery13378192clatter_y
cluttered12185942cluttered
flattener12175172flattener
flattered13188642flattered
flatterers13175912flatterers
flutterer12185262flutterer
latherer111310452_latherer
letterer8259222_letterer
litterer82810172_litterer
patterer103112182_patterer
plasterer1178112plasterer
scatterer11186292scatterer
shatterer12177202shatterer
smatterer11185812smatterer
alterer72714013__alterer
banterer102811783_banterer
barterer102711653_barterer
battener10369403_battener
battered113315073_battered
batterers113110723_batterers
bitterer10309783_bitterer
blathered15168363blathered
blatherers15175343blatherers
blatter94415653blatt__er
blatters104414093blatter_s
blusterer11176293blusterer
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
chafferer20133923chafferer
chamferer19154693chamferer
chaptered17176803chaptered
chartered15158403chartered
charterers15146053charterers
chastener1445703chastener
chatter124416643chatt__er
chatters134213953chatter_s
chattery16357273chatter_y
chattier1337513chatt_ier
chittered15166413chittered
clabbered16184763clabbered
clambered16146133clambered
clamberers16174113clamberers
clamorer1236913cla_morer
clattering13109233clattering
clavered14187633cla_vered
cleverer1334563cl_everer
clustered12186613clustered
clutter94211663clutt__er
clutters103210353clutter_s
cluttery13346323clutter_y
cottered112511743c_ottered
cratered1149693cra_tered
falterer11239873_falterer
fattener11268113_fattener
fetterer11207813_fetterer
flattened13185303flattened
flatteners13164153flatteners
flatter103815963flatt__er
flatteries1347423flatteries
flatters113814203flatter_s
flattery14338293flatter_y
flittered13196253flittered
fluttered13185943fluttered
flutterers13184593flutterers
fritterer12234403fritterer
gatherer12147913_gatherer
glittered11195413glittered
lateener835763_lateener
lathered121512333_lathered
latherers12158853_latherers
latter65027893_latt__er
latterly1136063_latterly
lettered92910783_lettered
letterers9228113_letterers
littered92511383_littered
litterers9228193_litterers
loiterer837083_loiterer
mattered112412913_mattered
mutterer10218913_mutterer
nattered92011633_nattered
palterer102411293_palterer
pattered112714213_pattered
patterers112410133_patterers
plastered1288913plastered
plasterers1286123plasterers
platter93917413platt__er
platters103415283platter_s
potterer102310263_potterer
putterer10209913_putterer
quarterer18145723quarterer
rattener8238533_rattener
scattered12197363scattered
scatterers12205043scatterers
shattered13178213shattered
shatterers13185723shatterers
slanderer1046673slanderer
slathered13148553slathered
slattern837093slatter_n
slatterns935363slatterns
slaverer11196993sla_verer
smattered12186793smattered
smatterers12174873smatterers
spattered12187653spattered
splattered13163943splattered
splutterer12132743splutterer
sputterer11165263sputterer
stutterer9164913stutterer
tattered92011453_tattered
titterer8268523_titterer
totterer8217793_totterer
twitterer1243303twitterer
utterer71910463__utterer
waterer103314083_wa_terer
yattered12239543_yattered

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.453394461.4
2DLD Change Limit1486411377.26620457.1
3Display Results1371370.0602283.3
 (SQL Overall)1786911377.77922970.9
 
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.