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

31 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
revolutionarily218206(None) 
evolutionarily2092111_evolutionarily
revolutionaries1872242revolutionaries
revolutionary1963492revolutionar__y
devolutionary2062983devolutionar__y
evolutionary1853323_evolutionar__y
coevolutionary22102384coevolutionar__y
revolutionise16134484revolution__ise
revolutionising19112144revolutionising
revolutionist16106184revolution__ist
revolutionize25133444revolution__ize
revolutionizing28112314revolutionizing
unrevolutionary2171684unrevolutionar__y
devolutionist17135155devolution__ist
devotionally1953725devo__tiona_lly
elocutionary1762375_elocutionar__y
evolutionism17105125_evolution__ism
evolutionist15126815_evolution__ist
involutional1553575involutiona__l_
reflationary1872615re_flationar__y
relationally1555075re__lationa_lly
revoltingly1852815revol_ti_n__gly
revolution13117565revolution_____
revolutionised18133155revolution_ised
revolutionises17154005revolution_ises
revolutionists17145125revolution_ists
revolutionized27122795revolution_ized
revolutionizer26132645revolution_izer
revolutionizers27152115revolutionizers
revolutionizes26153165revolution_izes
revolutions1497635revolution____s

Search took 5 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.436409841.7
2DLD Change Limit65874314.28315380.3
3Display Results31310.0301033.3
 (SQL Overall)178691314.74937627.1
 
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.