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

47 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
involutional155357(None) 
invocational1754412invocational
involution1345942involution__
involutions1445902involution_s
inhalational1553043inhalational
innovational1553833innovational
intonational1256003intonational
invitational1554903invitational
involuting1444613involuti_n_g
volitional1345413__volitional
avocational1645184_avocational
convocational2054474convocational
convolution1645124convolution__
convolutions1745194convolution_s
devolution1486284devolution__
devolutionary2062984devolutionary
devolutions15106264devolution_s
devotional1444674devo__tional
evolution12117094_evolution__
evolutionary1853324_evolutionary
evolutions13107044_evolution_s
illusional1053404i__llusional
indicational1545754indicational
inflectional1754384inflectional
informational1854344informational
insertional1147464in_sertional
insolation10410214insolation__
insolations1149184insolation_s
institutional1353504institutional
instructional1555094instructional
intentional11128844in_tentional
intuitional1155294in_tuitional
invitationals1652744invitationals
invocation1547544invocation__
invocations1647064invocation_s
involucral1551574involu__cral
irrotational1254024irrotational
nonvocational1853704nonvocational
notational1048124_n_otational
notional849404_n_o__tional
revolution13117564revolution__
revolutionary1963494revolutionary
revolutions1497634revolution_s
valuational1444044__valuational
vocational1546954__vocational
volution1198604__volution__
volutions12108394__volution_s

Search took 7 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.393454684.5
2DLD Change Limit124790476.03020694.9
3Display Results47470.0162937.5
 (SQL Overall)178691476.43927751.4
 
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.