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

35 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
noninformations207313(None) 
noninformation1973311noninformation_
conformations2046723co__nformations
disinformations2173303disinformations
informations17127033___informations
misinformations2282583misinformations
nonimportations1962103nonimportations
confirmations2055674co__nfirmations
conformation1947324co__nformation_
disinformation2063334disinformation_
information16147714___information_
misinformation2172594misinformation_
nonimportation1862224nonimportation_
confirmation1946185co__nfirmation_
conformational21153715co__nformational
connotations1447285con_n_o_tations
deformations1846845___deformations
formations1538205_____formations
informatics1854105___informati_cs
informational1854345___informational
infuriations1547445___infuriations
malformations2053075__malformations
nominations13410535nomin____ations
nonconformities2273065nonconformiti_es
nonimplications21122885nonimplications
noninfectious1862535noninf__ectious
nonnormative1754865non_n_ormati_ve
nonuniformities2071395nonuniformiti_es
notifications1848235noti_f_ications
preformations2045715__preformations
reconfirmations2283085reconfirmations
reformations1747605___reformations
transformations2062825transformations
uninformative2162235_uninformati_ve
vociferations2153115voci_fer_ations

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.403443402.0
2DLD Change Limit65874354.51614586.8
3Display Results35350.0301166.7
 (SQL Overall)178691354.94936106.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.