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

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

81 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
devolutionary206298(None) 
evolutionary1853321_evolutionary
revolutionary1963491revolutionary
coevolutionary22102382coevolutionary
deflationary1952273de_flationary
delusionary1552503de__lusionary
devolution1486283devolution___
devolutionist17135153devolutionist
devolutions15106263devolution__s
elocutionary1762373_elocutionary
evolutionarily2092113_evolutionarily
revolutionarily2182063revolutionarily
unrevolutionary2171683unrevolutionary
ablutionary1652274__ablutionary
abolitionary1762234_abolitionary
devolutionists18144414devolutionists
devotional1444674devo__tiona_l
devotionally1953724devo__tionally
devotionals1552994devo__tionals
evolution12117094_evolution___
evolutionism17105124_evolutionism
evolutionist15126814_evolutionist
evolutions13107044_evolution__s
exclusionary2462244_exclusionary
illocutionary1861314illocutionary
involutional1553574involutiona_l
reflationary1872614re_flationary
revolution13117564revolution___
revolutionaries1872244revolutionaries
revolutionise16134484revolutionise
revolutionist16106184revolutionist
revolutionize25133444revolutionize
revolutions1497634revolution__s
cautionary1553925___cautionary
coevolution1654225coevolution___
coevolutions1754085coevolution__s
conclusionary2062105conclusionary
delusional1153305de__lusiona_l
demolition1376985demolition___
demolitionist1654515demolitionist
demolitions1446525demolition__s
depositional1554625depositiona_l
desolatingly1752695desolati_ngly
desolation11311405desolation___
desolations12310595desolation__s
devaluation1547075devaluation___
devaluations1646355devaluation__s
devotion1256765devo__tion___
devotions1356595devo__tion__s
dictionary1654595d___ictionary
discretionary1962275discretionary
diversionary1962035div_ersionary
evolutionisms18124645_evolutionisms
evolutionists16145715_evolutionists
extortionary2262695_extortionary
geostationary1781445geostationary
illusionary1452615__illusionary
inflationary1852745_inflationary
involution1345945involution___
involutions1445905involution__s
lectionary1554825le___ctionary
petitionary1653765pe__titionary
precautionary2062265precautionary
probationary1953225_probationary
reactionary1653695re__actionary
resolution1097735resolution___
resolutions11117795resolution__s
reversionary1852065rev_ersionary
revisionary1773525rev__isionary
revoltingly1852805revol_ti_ngly
revolutionised18133155revolutionised
revolutionises17154005revolutionises
revolutionists17145125revolutionists
revolutionized27122795revolutionized
revolutionizer26132645revolutionizer
revolutionizers27152115revolutionizers
revolutionizes26153165revolutionizes
secretionary1752435se_cretionary
volitional1345415__volitiona_l
volution1198605__volution___
volutions12108395__volution__s

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 Filter1786911247900.390458182.1
2DLD Change Limit124790818.37614898.5
3Display Results81810.0461760.9
 (SQL Overall)178691818.81220278.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.