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

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

72 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
tastemakers175251(None) 
tastemaker1652741tastemaker_
automakers1643873_automakers
hatmakers18105173ha_t_makers
pacemakers20104263pa_cemakers
platemakers1952823platemakers
tentmakers1643093tent_makers
wastepapers1851613wastepapers
wastewaters17142503wastewaters
anteaters939344_ante_aters
assemblers1452884_assemblers
attempers13103504_attem_pers
attempters1442664_attempters
automaker1544664_automaker_
capmakers1944724ca__pmakers
caretakers1644504ca_retakers
carmakers1736924ca__rmakers
casemates1349524cas_emate_s
castraters1246474cast_raters
diemakers1645264__diemakers
distempers1544294distem_pers
easterners1044824easte_rners
fasteners12237054faste__ners
glassmakers1852284glas_smakers
hasteners12267814haste__ners
hatmaker1785354ha_t_maker_
haymakers21104554ha__ymakers
homemakers2144664_homemakers
icemakers1744014__icemakers
lawmakers1843894la__wmakers
lovemakers1943074_lovemakers
mapmakers1944044ma__pmakers
matchmakers2452324matchmakers
mistakers15117084mist__akers
moviemakers2251834moviemakers
mythmakers2452194_mythmakers
noisemakers1752704noisemakers
pacemaker19104764pa_cemaker_
papermakers2153254papermakers
partakers1536564part__akers
peacemakers21102464peacemakers
phrasemakers2351684phras_emakers
platemaker1852904platemaker_
rainmakers1644064ra_inmakers
ratemeters1244994ra_temeters
ratepayers1541974ra_tepayers
remakers143811304___remakers
sailmakers1643784sa_ilmakers
saltshakers1851604saltshakers
shoemakers1943494_shoemakers
sneakers12308644__sne_akers
speakers14299454__spe_akers
stealers83412204__ste_alers
steamers103410874__ste_amers
steelmakers1752644__steelmakers
stemmers12378444__stem_mers
streakers13218134__streakers
tablemates1444694tablemate_s
taskmasters1752634tas_kmasters
tasteless935674taste__less
tasters74225644tast____ers
tautomers1144214tautom__ers
teamakers1544874t__eamakers
tentmaker1543114tent_maker_
toastmasters1452264toast_masters
toolmakers1643014t_oolmakers
warmakers1845634wa__rmakers
wastebaskets216694wastebaskets
wastepaper1751824wastepaper_
wastewater16143004wastewater_
watchmakers2552234watchmakers
winemakers1944284_winemakers

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819728.98316566.7
3Display Results72720.0461565.2
 (SQL Overall)178691729.45218905.1
 
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.