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

60 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
uncertainness157233(None) 
uncertainnesses1781352uncertainnesses
uncertainties1592423uncertainties
certainest1248864__certai_nest
curtainless1351934__curtainless
entertainers1253664entertai_ners
uncertain1146204uncertai_n___
uncertainly1653224uncertai_n_ly
uncertainty1652854uncertai_n_ty
uncleanness1352844unc_lea_nness
uncurtained1452984uncurtai_ne_d
unworthiness1853244unworthi_ness
acceptingness2061735accept_ingness
ascertained1452295ascertai_ne_d
ascertainment1761885ascertainment
ascertainments1861745ascertainments
ascertains1244265ascertai_n__s
certainer1146195__certai_ne_r
certainties1353765__certainties
concertedness1855835concert_edness
entertained1245175entertai_ne_d
entertainer1154485entertai_ne_r
entertainment1563055entertainment
entertainments1672455entertainments
entertains1047625entertai_n__s
inertness947975in_ert___ness
intertwines1446645intertwi_ne_s
nerdiness10208335_n_er_di_ness
nerviness12226875_n_er_vi_ness
ulcerations1346365ulceration__s
unbecomingness2171025unbecomingness
uncanniness1353405unc___anniness
uncertified17124625uncert_ifie_d
unchangingness2161225unchangingness
uncleanliness1562295uncleanli_ness
uncommonness1861705unc_ommonness
uncouthness1652755uncout__hness
underlines111512115under_li_ne_s
undermanned1544185underma_nne_d
undermines131710665under_mi_ne_s
underpinned1544055under_pinne_d
undertakers1643815underta__kers
undertakes1547695underta__ke_s
undertakings1894035undertakin_gs
undertaxes1847025underta__xe_s
undertints1148285undert_i_n_ts
undertones1148975undert__one_s
unearthliness1652395unearthliness
uneasiness1046395un_e__asiness
unevenness1343875un_e__venness
unfairness1342815un___fairness
unfeelingness1772105unfe_elingness
unhealthiness1962425unhealthi_ness
universalness1662205universa_lness
unreadiness1244655un__readiness
unruliness1044635un__ruli_ness
unseemliness1452365unseemli_ness
unseriousness1356425unseriousness
unsettledness1462445unsettledness
unwariness1365885unwar__i_ness

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 Filter1786911247900.406440125.6
2DLD Change Limit124790609.15613629.3
3Display Results60600.0461304.3
 (SQL Overall)178691609.60818598.1
 
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.