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

70 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
undernutritions1619190(None) 
undernutrition15192051undernutrition_
overnutritions1763123_overnutritions
supernutritions1763433supernutritions
overnutrition1663384_overnutrition_
supernutrition1673624supernutrition_
deglutitions1452155__deglut_itions
dentitions1148855__de_n_t_itions
detritions1148955__de___tritions
indentations1347885inde_n_t_ations
malnutritions15101865__malnutritions
nonnutritious1361535_n_onnutritious
nutritions1066515_____nutritions
sternutations1353755_sternut_ations
undercutting1653765undercut__ti_ng
underinflations1962325underinflations
underutilizes2362215under_ut_ilizes
undervaluations1982285undervaluations
underwriting1754125under__writi_ng
concentrations1877076conce_n_trations
contritions13410916___con_tritions
deglutition1352346__deglut_ition_
demonstrations1795676__demonstrations
denaturations1444956__de_naturations
denigrations1447356__de_nigrations
denotations1239856__de_not_ations
dentations11413636__de_n_t_ations
dentition1049636__de_n_t_ition_
denudations1346346__de_nu_dations
denunciations1653886__de_nunciations
deputations1448346__de_put_ations
detrition1049136__de___trition_
deuterations1348086__de__uterations
elutriations1246026___e_lutriations
eruditions1146106___er_u_ditions
indentation1248376inde_n_t_ation_
indentions1149066inde_n____tions
indurations1249586ind___u_rations
intenerations1347466inte_n_erations
interpositions1685126inter_positions
interruptions1565736interru__ptions
malnutrition14132006__malnutrition_
mercurations1646566__mercu_rations
modernisations1752726modern_isations
modernizations2654936modern_izations
nutrition966736_____nutrition_
nutritious1064366_____nutritious
parturitions1453786__partu_ritions
penetrations1448856__pe_netrations
permutations1646506__permut_ations
perpetrations1746376__perpetrations
sternutation1253966_sternut_ation_
superstitions15176786super_st_itions
uncircumcisions2081276uncircumcisions
underactivities2162746underactiviti_es
underestimation1872256underestimation_
underinflation1862386underinflation_
underletting1454186underlet__ti_ng
underpricing1853986under__prici_ng
underrating1388256under___rati_ng
understating1446546under_st_ati_ng
undertricks1873016under__tr__icks
underutilize2272536under_ut_ili_ze
underutilized2462466under_ut_ilized
underutilizing2561846under_ut_ilizing
undervaluation1882686undervaluation_
underwriters1652806under__writ_ers
underwrites1545186under__writ__es
underwritten1652386under__written_
undulations1246056und___u_lations

Search took 9 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 Limit95024707.59312514.7
3Display Results70700.0461521.7
 (SQL Overall)178691707.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.