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

47 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
informalities186428(None) 
formalities16137812__formalities
normalities13148102_n_ormalities
abnormalities1752563abnormalities
immoralities1655733immor_alities
immortalities1754203immortalities
infertilities1656203infertilities
infirmities16114503infirm__ities
informality1953893informalit__y
informatics1854103informa__tics
internalities1358633internalities
unmoralities1485553unmor_alities
amoralities1347414_amor_alities
animalities1348974an__imalities
conformities1954914conform__ities
deformalizes2754864deformali_zes
deformities1744274deform__ities
enormities1246894en_orm__ities
formabilities2046994__formabilities
formalises15258994__formali_ses
formalizes242710074__formali_zes
incommodities2063074incommodities
indocilities1555634indo_cilities
inequalities2156144in_equalities
infantilities1665264infantilities
inferiorities1653724inferiorities
infidelities1653764inf_idelities
infirmaries1652994infirma__ries
informants1544634informa_nt__s
information16147714informa__tion
informations17127034informati_ons
informative1965154informa__tive
inhumanities1783334in_humanities
integralities1495504integralities
irrealities1146204i__rrealities
lognormalities1761694lognormalities
moralities121111924__mor_alities
mortalities1348414__mortalities
nodalities11138584_n_o_dalities
normalcies1443834_n_ormal_cies
normalises12228494_n_ormali_ses
normalizes21259644_n_ormali_zes
oralities91214114___or_alities
reformabilities2264534reformabilities
subnormalities1861714subnormalities
uniformities1753054uniform__ities
unrealities1147534un__realities

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.1261418182.5
2DLD Change Limit95024477.26613077.9
3Display Results47470.0301566.7
 (SQL Overall)178691477.42224075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.