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

28 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
noninstrumental1713184(None) 
instrumental1473403___instrumental
instrumentals1582974___instrumentals
instrument1255575___instrument__
instrumentally1973015___instrumentally
instrumented1552155___instrumented
instruments1354685___instrument_s
nondepartmental2071355nondepartmental
nonexperimental2671765nonexperimental
nongovernmental2181695nongovernmental
noninstallment1681785noninstallment__
noninstallments1781685noninstallment_s
incremental1556006___in_cremental
instrumentalism19143396___instrumentalism
instrumentalist17133576___instrumentalist
instrumentality2072706___instrumentality
instrumenting1662176___instrumenting
monumental1455216mo__n___umental
nonincumbent1862376nonin__cumbent__
nonincumbents1961906nonin__cumbent_s
nonintegral1252426nonin_t___egral
nonintellectual17131546nonin_tellectual
nonjudgmental2471496no__njudgmental
nonmental11410856no__n____mental
nonsequential22103396no__nsequ_ential
nonstructural1573676no__nstructural
nonstudent1154156no__nst_udent__
nonstudents1252916no__nst_udent_s

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 Filter178691950240.340525561.8
2DLD Change Limit95024287.36012910.9
3Display Results28280.0161750.0
 (SQL Overall)178691287.71623158.5
 
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.