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

93 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
flatterers1317591(None) 
clatterers12155421clatterers
flatteners13164151flatteners
flatterer12187681flatterer_
flutterers13184591flutterers
batterers113110712_batterers
blatherers15175342blatherers
chatterers15205462chatterers
clatterer11186992clatterer_
falterers12238032f_alterers
fatteners12236872f_atteners
fetterers12267042f_etterers
flattener12175172flattener_
flattered13188632flattere_d
flatteries1347422flatteries
flatters113814202flatt__ers
flutterer12185262flutterer_
fritterers13203392fritterers
latherers12158852_latherers
letterers9228112_letterers
litterers9228192_litterers
patterers112410122_patterers
plasterers1286122plasterers
scatterers12205042scatterers
shatterers13185722shatterers
smatterers12174872smatterers
alterers82512493__alterers
banterers112410003_banterers
barterers11269633_barterers
batteners11238163_batteners
batterer102713213_batterer_
blatherer14176723blatherer_
blattered12198573blattere_d
blatters104414093blatt__ers
blusterers12174993blusterers
caterers102814403_ca_terers
charterers15146053charterers
chatterer14196843chatterer_
clamberers16174113clamberers
clattered12178413clattere_d
clatters103313913clatt__ers
falterer11239863f_alterer_
fasteners12237053f_asteners
fattener11268113f_attener_
fetterer11207813f_etterer_
filterers12206973f_ilterers
flatliners13254073flatliners
flattened13185303flattene_d
flattens11357483flatt__ens
flatter103815963flatt__er_
flattering1498743flattering
flattery14338293flatt__ery
flatwares1544773flatware_s
flavorers1563983fla_vorers
flittered13196253flittere_d
flitters114312173flitt__ers
flowerers1544503fl_owerers
fluttered13185943fluttere_d
flutters114010823flutt__ers
fosterers12238023f_osterers
fracturers15123213fracturers
fritterer12234403fritterer_
fruiterers1343003fruiterers
furtherers1643323furtherers
gatherers13156883_gatherers
lateeners945563_lateeners
latherer111310453_latherer_
letterer8259223_letterer_
litterer82810173_litterer_
loiterers936263_loiterers
mutterers11247373_mutterers
palterers11249533_palterers
patterer103112173_patterer_
plasterer1178113plasterer_
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.423422437.4
2DLD Change Limit140603936.11023011.9
3Display Results93930.0462021.7
 (SQL Overall)178691936.57927160.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.