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

26 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
miscaptioned1915194(None) 
miscaption1644762miscaption__
miscaptions1744182miscaption_s
captioned1445763___captioned
misatoned1246693mis_a_t_oned
miscaptioning2061403miscaptioning
uncaptioned1652503_uncaptioned
cautioned1245364___cautioned
disciplined1753544discipli_ned
misaligned1443584mis_a_ligned
misassigned1552034mis_assigned
misatone1049764mis_a_t_one_
misatones1148934mis_a_t_ones
misbuttoned1651384mis_buttoned
miscarried1543824miscarri__ed
miscasting1557074miscasti_n_g
miscataloged1861134miscataloged
miscoined1448444misc__oi_ned
miscopied1647174miscop_i__ed
misfunctioned2161714misfunctioned
mispositioned1862194mispositioned
missioned1248604mis___sioned
recautioned1483184_recautioned
restationed1244374resta_tioned
stationed1046144__sta_tioned
vacationed1643424_vaca_tioned

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 Filter1786911247900.390458182.1
2DLD Change Limit124790267.37616918.4
3Display Results26260.0161625.0
 (SQL Overall)178691267.78222962.1
 
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.