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

61 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
miterer92511331miterer_
miterers10219681miterers
miserere1049272miserere
mitered103213232mitere_d
miterwort1476702miterwort
alterer72714003alterer_
alterers82512493alterers
antevert1148993antevert
bitterer10309773bitterer_
bitterest1147713bitterest
caterer92815943caterer_
caterers102814403caterers
ditherer12187763ditherer_
ditherers13196683ditherers
enterer72015633enterer_
enterers82214153enterers
filterer11258143filterer_
filterers12206973filterers
interest8319183interest
iterant7317783_iterant
literary1147753literary
litterer82810173litterer_
litterers9228193litterers
loiterer837083loiterer_
loiterers936263loiterers
maturer938983maturer_
maturers1037383maturers
maturest1039703maturest
merer75126233m__erer_
merest84725113m__erest
metered103514013metere_d
minaret9520683minare_t
misereres1148183misereres
misevent1349223misevent
mistreat10313113mistreat
miter75734793mit__er_
mitering113015403mitering
miters84328783mit__ers
miterworts1584233miterworts
mither114218563mit_her_
mithers123516733mit_hers
mitier83620673mit_ier_
mitiest93520053mit_iest
mitre75522423mit_re__
mitred94414343mit_re_d
mitres83922073mit_re_s
mitrewort1465293mitrewort
mutterer10218913mutterer_
mutterers11247373mutterers
sievert10613293si_evert
terret63425623__terret
titterer8268523titterer_
titterers9236993titterers
utterer71910463utterer_
utterers8218653utterers
waterer103314073waterer_
waterers112312783waterers
winterer112110443winterer_
winterers12209723winterers
witherer14187953witherer_
witherers15146843witherers

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit146162617.93618417.6
3Display Results61610.0331848.5
 (SQL Overall)178691618.39221293.0
 
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.