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

72 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
revolutionising1911214(None) 
revolutionizing28112311revolutionizing
revolutionise16134483revolutionis__e
revolutionised18133153revolutionis_ed
revolutionises17154003revolutionis_es
revolutionist16106183revolutionis__t
revolutionists17145123revolutionis_ts
devolutionist17135154devolutionis__t
devolutionists18144414devolutionis_ts
evolutionism17105124_evolutionis__m
evolutionisms18124644_evolutionis_ms
evolutionist15126814_evolutionis__t
evolutionists16145714_evolutionis_ts
revolutionaries1872244revolutionaries
revolutionarily2182064revolutionarily
revolutionize25133444revolution__ize
revolutionized27122794revolutioni_zed
revolutionizer26132644revolutioni_zer
revolutionizers27152114revolutionizers
revolutionizes26153164revolutioni_zes
revolutions1497634revolution_s___
devolutions15106265devolution_s___
evolutionarily2092115_evolutionarily
evolutions13107045_evolution_s___
recautioning1553765re_caution__ing
recolonizing2455365recol___onizing
repositioning1653675reposition__ing
resolutions11117795resolution_s___
revolution13117565revolutio____n_
revolutionary1963495revolution__ary
routinizing2195445r__o_uti_nizing
volatilising1652345__volati_lising
coevolutions1754086coevolution_s___
colonising1347646__col___onising
cutinising1345616____cuti_nising
decolonizing2585076decol___onizing
demolitionist1654516demolitionis__t
demolitionists1763476demolitionis_ts
depoliticizing2961736depoliti_cizing
devolution1486286devolutio____n_
devolutionary2062986devolution__ary
elocutionist1455096_elocutionis__t
elocutionists1554316_elocutionis_ts
evolution12117096_evolutio____n_
evolutionary1853326_evolution__ary
gelatinizing2354056ge__lati_nizing
involutions1445906involution_s___
lionising1046466____l__ionising
politicising1753506__politi_cising
preportioning1853606prepo_rtion__ing
reauthorizing2692556re__authorizing
rebuttoning1452066re__button__ing
recognising1544546reco____gnising
reconditioning1872516recondition__ing
relativizing2553946re__lati_vizing
relumining1345646re__lumi_n__ing
resolution1097736resolutio____n_
restationing1354266re_station__ing
reutilizing2147016re___uti_lizing
revalorizing2553836reval___orizing
revaluations1557636revaluation_s___
revelations14410306revelation_s___
revitalising1654666rev__it_alising
revocations16410316revocation_s___
revolting1339636revol_t_____ing
scrutinising1552026__scruti_nising
skeletonising1861726_skelet_onising
solubilising1552316__solubi_lising
teutonizing2145336te___ut_onizing
unionising1145486_____unionising
volatilizing2553686__volati_lizing
volutions12108396__volution_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.1231452772.4
2DLD Change Limit95024726.90613759.6
3Display Results72720.0461565.2
 (SQL Overall)178691727.07525256.7
 
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.