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 “clatterers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
clatterers1215542(None) 
chatterers15205461chatterers
clatterer11186981clatterer_
flatterers13175911flatterers
batterers113110712_batterers
blatherers15175342blatherers
caterers102814402c_a_terers
charterers15146052charterers
chatterer14196842chatterer_
clamberers16174112clamberers
clattered12178402clattere_d
clatters103313912clatt__ers
flatteners13164152flatteners
flatterer12187672flatterer_
flutterers13184592flutterers
latherers12158852_latherers
letterers9228112_letterers
litterers9228192_litterers
patterers112410122_patterers
plasterers1286122plasterers
scatterers12205042scatterers
shatterers13185722shatterers
smatterers12174872smatterers
alterers82512493__alterers
banterers112410003_banterers
barterers11269633_barterers
batteners11238163_batteners
batterer102713213_batterer_
blatherer14176713blatherer_
blattered12198563blattere_d
blatters104414093blatt__ers
blusterers12174993blusterers
caperers122611723c_a_perers
capturers1344633c_apturers
careerers1137243c_areerers
caterer92815943c_a_terer_
cateress102311613c_a_teress
catheters1437013c_atheters
catteries11815523c_atteries
chafferers21153173chafferers
chamferers20153953chamferers
charterer14197323charterer_
chasteners1554793chasteners
chattered15197993chattere_d
chatters134213953chatt__ers
clamberer15185273clamberer_
clamorers1345783cla_morers
clatter94014973clatt__er_
clattering13109233clattering
clattery13378193clatt__ery
cluttered12185943cluttere_d
clutters103210353clutt__ers
falterers12238033_falterers
fatteners12236873_fatteners
fetterers12267043_fetterers
flattener12175173flattener_
flattered13188623flattere_d
flatteries1347413flatteries
flatters113814203flatt__ers
flutterer12185263flutterer_
fritterers13203393fritterers
gatherers13156883_gatherers
lateeners945563_lateeners
latherer111310443_latherer_
letterer8259223_letterer_
litterer82810173_litterer_
loiterers936263_loiterers
mutterers11247373_mutterers
palterers11249533_palterers
patterer103112173_patterer_
plasterer1178103plasterer_
platters103415283platt__ers
potterers11218663_potterers
putterers11238363_putterers
quarterers19124823quarterers
ratteners9237263_ratteners
scatterer11186293scatterer_
shatterer12177203shatterer_
slanderers1145143slanderers
slatterns935363slatter_ns
slaverers12165993sla_verers
smatterer11185813smatterer_
splutterers13142163splutterers
sputterers12174583sputterers
stutterers10164303stutterers
titterers9236993_titterers
totterers9186813_totterers
twitterers1342673twitterers
utterers8218653__utterers
waterers112312783_wa_terers

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 Filter1786911406030.420425454.8
2DLD Change Limit140603905.95323618.8
3Display Results90900.0461956.5
 (SQL Overall)178691906.41927837.8
 
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.