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

80 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
smatterers1217487(None) 
scatterers12205041scatterers
shatterers13185721shatterers
smatterer11185811smatterer_
batterers113110712_batterers
chatterers15205462chatterers
clatterers12155422clatterers
flatterers13175912flatterers
mutterers11247372_mutterers
patterers112410122_patterers
scatterer11186292scatterer_
shatterer12177202shatterer_
smattered12186782smattere_d
smatters104011712smatt__ers
smotherers1543812smotherers
sputterers12174582sputterers
stutterers10164302stutterers
alterers82512493__alterers
banterers112410003_banterers
barterers11269633_barterers
batteners11238163_batteners
batterer102713213_batterer_
blatherers15175343blatherers
caterers102814403_ca_terers
charterers15146053charterers
chatterer14196843chatterer_
clatterer11186983clatterer_
falterers12238033_falterers
fatteners12236873_fatteners
fetterers12267043_fetterers
flatteners13164153flatteners
flatterer12187673flatterer_
flutterers13184593flutterers
fritterers13203393fritterers
gatherers13156883_gatherers
latherers12158853_latherers
letterers9228113_letterers
litterers9228193_litterers
mattered112412903_mattere_d
matters94421753_matt__ers
mattress1036533_matt_ress
maturers1037373_ma_turers
miterers10219683_m_iterers
mutterer10218913_mutterer_
palterers11249533_palterers
patterer103112173_patterer_
plasterers1286123plasterers
potterers11218663_potterers
putterers11238363_putterers
quarterers19124823quarterers
ratteners9237263_ratteners
saunterers1044383saunterers
scamperers1643473scamperers
scattered12197353scattere_d
scatters103612753scatt__ers
shattered13178203shattere_d
shatters113313903shatt__ers
shelterers1344343shelterers
slanderers1145143slanderers
slatterns935363slatter_ns
slaverers12165993sla_verers
smatter93613333smatt__er_
smattering1397583smattering
smatterings14103843smatterings
smotherer1444633smotherer_
spattered12187643spattere_d
spatters103914703spatt__ers
splutterers13142163splutterers
sputterer11165263sputterer_
staggerers1242933staggerers
stammerers1443133stammerers
steerers82511353s__teerers
stutterer9164913stutterer_
swaggerers1542233swaggerers
swatters113911793swatt__ers
titterers9236993_titterers
totterers9186813_totterers
twitterers1342673twitterers
utterers8218653__utterers
waterers112312783_wa_terers

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 Filter1786911406030.1561145455.1
2DLD Change Limit140603806.86020496.1
3Display Results80800.0302666.7
 (SQL Overall)178691807.04625360.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.