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

92 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
songsters104611(None) 
songster935791songster_
gangsters11205732gangsters
monsters103314552mon_sters
songstress1152412songstress
youngsters1441972youngsters
banisters11189473banisters
boasters103915663bo_asters
bolsters103712453bo_lsters
boosters104013443bo_osters
canisters112310193canisters
coasters104317333co_asters
confuters1437793confuters
congeners122511133congeners
congers104223233cong__ers
contesters12410183contesters
costers94128333co__sters
doomsters1236173doomsters
dopesters1237283dopesters
dragsters1134333dragsters
foresters12312533foresters
fosters104220103fo__sters
gagsters10317083_gagsters
gangster10215773gangster_
ganisters10248313ganisters
hoisters113513483ho_isters
holsters113211943ho_lsters
honester1139713honester_
hoopsters1445693hoopsters
jokesters2044443jokesters
jousters153210423jo_usters
lobsters10268743lo_bsters
longers84819543long__ers
longspurs1242173longspurs
ministers1139623ministers
minsters103813923min_sters
mobsters12359063mo_bsters
molesters1198873molesters
monastery1444373monastery
mongers104217273mong__ers
monoesters1245993monoesters
monster93214603mon_ster_
monstera10318883mon_stera
monsteras11318243mon_steras
munsters104010553mun_sters
nesters74422793__nesters
nonusers8268003nonus_ers
nonvoters12136463nonvoters
oldsters996733_oldsters
ousters74122793_o_usters
oysters103411693_o_ysters
pensters103012123pen_sters
pinasters1136823pinasters
pollsters1137173pollsters
posters93928013po__sters
punsters103310583pun_sters
roadsters1035103roadsters
roasters83615933ro_asters
roisters83615553ro_isters
roosters83514663ro_osters
rosters73727543ro__sters
rousters84315683ro_usters
roysters113610533ro_ysters
sangers84421943sang__ers
scamsters1334993scamsters
seamsters1136333seamsters
semesters1139123semesters
shysters14106463s_hysters
sighters122510603s_ighters
singers83824703sing__ers
sinister838583sinister_
sinters74024083sin__ters
sisters73721593s__isters
slighters1346713slighters
snifters11318613s_nifters
snorters83410583s_norters
sodbusters1342593sodbusters
sonders83820713son__ders
songless9218823song_less
songwriters1552103songwriters
sonneteers1042933sonneteers
sonsier7711743son_sier_
sorters74221133so__rters
souters74422603so__uters
spinsters1136613spinsters
spongers1137603spong__ers
suggesters1243433suggesters
toasters83912723to_asters
tongers84116013tong__ers
tungstens1042223tungstens
youngster1341963youngster_
zosters163015413zo__sters

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.406440125.6
2DLD Change Limit148641926.72022119.2
3Display Results92920.0432139.5
 (SQL Overall)178691927.16924925.5
 
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.