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

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

58 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
minsters10381392(None) 
ministers1139621ministers
minster93914321minster_
minters93822471min_ters
misters93927511mi_sters
monsters103314551monsters
munsters104010551munsters
bisters93922612bi_sters
diasters92913182diasters
diesters92513602diesters
fibsters13126412fibsters
hinters103719582hin_ters
hipsters13268792hipsters
instars7411132_instars
insteps936572_insteps
inters64328052_in_ters
kiesters123310152kiesters
linters73822632lin_ters
listers74026532li_sters
masters94628922m_asters
meisters103313842meisters
milters93619092mi_lters
mincers113714852min_cers
minders103720122min_ders
miners84126632min__ers
minglers113011292minglers
minister10410362minister_
minivers1337482minivers
minstrel1046912minstrel
minstrels1145692minstrels
minter84425102min_ter_
minuter93510412minuter_
minutes93513442minute_s
misers85025702mi_s_ers
missteers1135912missteers
missteps12156142missteps
mister84728562mi_ster_
misterm114314512mi_sterm
misterms123711352mi_sterms
miters84328782mi__ters
mobsters12359062mobsters
monster93214602monster_
monstera10318882monstera
monsteras11318242monsteras
muensters1143252muensters
munster93710522munster_
musters94522512m_usters
pensters103012122pensters
piasters102912812piasters
pinasters1136822pinasters
punsters103310582punsters
rinsers73815742rins_ers
sinters74024082sin_ters
sisters73721592si_sters
spinsters1136612spinsters
tinters74221112tin_ters
tipsters10278522tipsters
winters103720482win_ters

Search took 5 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 Filter1786911210590.390458182.1
2DLD Change Limit121059583.71632577.8
3Display Results58580.0163625.0
 (SQL Overall)178691584.12243350.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.