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

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

30 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
interdigitating1862041interdigitating_
interdigitation1763143interdigitati_on
interdigitate1562814interdigitat___e
interdigitated1762104interdigitat__ed
interdigitates1662434interdigitat__es
ingurgitating1652045ingur__gitating_
interdicting1647455interd__i_cting_
interknitting1853285inter_knit_ting_
intermediating1853985intermedi_ating_
intermitting1547255inter__mit_ting_
interrogating1556665interrog__ating_
intervisitation1862855intervisitati_on
incriminating1854176in_cr_iminating_
integrating1349496inte___g_rating_
intercalating1656506inter__calating_
intercutting1545946inter__cut_ting_
interdiffusing22111616interdi_ffusing_
intergrading1545986inter__g_rading_
intergrafting1854146inter__grafting_
interknotting1852666inter_knot_ting_
intermatting1547176inter__mat_ting_
interpellating1754536inter_pellating_
interpermeating2063076interpermeating_
interpolating1657796inter__polating_
interrelating1457296inter__relating_
intertwisting1753316inter_twi_sting_
intimidating1654746int___imidating_
intromitting1583796int_r_omit_ting_
investigating1853346investig__ating_
invigilating17113556in___vigilating_

Search took 6 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 Filter178691658740.310576422.6
2DLD Change Limit65874305.53311905.7
3Display Results30300.0301000.0
 (SQL Overall)178691305.87330425.8
 
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.