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

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

46 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
parliamentarian1991181parliamentarian_
parliamentary2091614parliamentar___y
armamentaria1672615_ar_mamentari__a
alimentation14105336_a_li_mentation_
alimentations1594996_a_li_mentations
armamentarium1671766_ar_mamentari_um
parliament1454656parliament______
parliaments1553576parliament_____s
unparliamentary228766unparliamentar___y
alimentary1553987_a_li_mentar___y
alimenting1344507_a_li_ment__i_ng
argumentation16103587_ar_gumentation_
argumentations1783277_ar_gumentations
documentarian18143037__documentarian_
documentarians19162647__documentarians
lamentation13106577___l_amentation_
lamentations1495987___l_amentations
laminarian1245327___l_amin_arian_
laminarians1354387___l_amin_arians
libertarian1353337___li_bertarian_
libertarians1453227___li_bertarians
ornamentation1573617_or_namentation_
ornamentations1673257_or_namentations
paramenta1368867par__ament_____a
parameterize25123287par__ame_teri_ze
parameterized27122517par__ame_terized
parameterizes26153017par__ame_terizes
parameterizing2861817par__ame_terizing
parametric1646937par__ame_t_ri__c
parametrize2474297par__ame_t_ri_ze
parametrized26103487par__ame_t_rized
parametrizes25104567par__ame_t_rizes
parametrizing2762727par__ame_t_rizing
pigmentation1754487p___igmentation_
pigmentations1854097p___igmentations
placentation1694157p__l_acentation_
placentations17103637p__l_acentations
planarian1147117p__l_a__n_arian_
planarians1245197p__l_a__n_arians
planetaria1254417p__l_ane_tari__a
praetorian1256637p_r__a_e_torian_
praetorians1364627p_r__a_e_torians
premillenarian1872087premillen_arian_
premillenarians1971837premillen_arians
proletarian1356217p_r__ole_tarian_
proletarians1455597p_r__ole_tarians

Search took 10 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.360496363.9
2DLD Change Limit95024468.61011036.5
3Display Results46460.0301533.3
 (SQL Overall)178691469.00019854.6
 
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.