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

34 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
uniformities175306(None) 
conformities1954923conformities
deformities1744283_deformities
enormities1246903en__ormities
infirmities16114503in_firmities
juniorities1853993juni_or_ities
multiformities2161643multiformities
nonuniformities2071393nonuniformities
unconformities2162503unconformities
uniformity1852403uniformit__y
universities1553453universities
abnormities1553054_abnormities
animosities1344914animo_sities
furmities1447544___furmities
inconformities2162764inconformities
informalities1864294in_formalities
informatics1854104in_formatics
minorities1249464_minor_ities
priorities1249154pri_or_ities
seniorities1148124seni_or_ities
unanimities1344814un_animities
unclarities1345334unclar_ities
unfortified1852914un_fortified
uniformed1544534uniform___ed
uniformer1443634uniform___er
uniformest1552844uniform___est
uniforming1643794uniform__ing
uniformitarian1971034uniformitarian
uniformitarians207954uniformitarians
uniformness1651984uniform_ness
uniformnesses1852084uniformnesses
uniforms1355044uniform____s
uninformative2162234uninformative
unmoralities1485564un_moralities

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 Filter1786911247900.390458182.1
2DLD Change Limit124790347.29617103.9
3Display Results34340.0301133.3
 (SQL Overall)178691347.71623158.5
 
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.