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

34 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
introspectional1972631introspectional_
introspection1764623introspection___
introspections1864063introspection__s
intersectional16146254inters_ectional_
introspecting18123574introspecti_n__g
introspectively2572214introspecti_vely
interjectional23195605int_erjectional_
introjection2156205intro_jection___
introjections2255785intro_jection__s
introspective2073575introspecti___ve
retrospection1784315retrospection___
retrospections1894175retrospection__s
inflectional1754386in___flectional_
insertional1147466in___s_ertional_
inspection1446666in___spection___
inspections1546426in___spection__s
instructional1555096instr___uctional_
insurrectional1662606in_surrectional_
intentional11128846int____entional_
interactional1557006int__eractional_
intersection14610186inters_ection___
intersections1598966inters_ection__s
intonational1256006int_o__national_
intraperitoneal1791196intr_aperitoneal_
intrapersonal1572886intr_ape_rsonal_
introduction1555786intro_duction___
introductions1655136intro_duction__s
introjecting2254256intro_jecti_n__g
introspect1474386introspect______
introspected1752846introspect____ed
introspects15103036introspect_____s
projectional2355426__pro_jectional_
retrospecting1863456retrospecti_n__g
retrospectively2572176retrospecti_vely

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 Filter178691658740.313570897.8
2DLD Change Limit65874347.9068332.2
3Display Results34340.0162125.0
 (SQL Overall)178691348.23521699.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.