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

63 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
importunateness197140(None) 
fortunateness16102843__fortunateness
importunate1553104importunat__e__
importunately2061704importunat__ely
importunities1762714importunit_ie_s
inordinateness1563264i_nordinateness
opportuneness17111804opportun__eness
coordinateness1762435_coordinateness
fortunatenesses1862505__fortunatenesses
immoderateness1982585immo_derateness
impoliteness1674245impo___liteness
importuners1552375importu____ners
importunes1444475importu____ne_s
impregnableness2262305imp_regnableness
inopportuneness1971015inopportun__eness
ornateness1046705___or__nateness
subordinateness18111645subordinateness
appropriateness1891586appropriateness
conjugateness2382756__conjugateness
determinateness1861846determinateness
disparateness1684186dispar___ateness
fortunates1345256__fortunat__e_s
ignorantness13111866ignor_an_t_ness
illiterateness1472616i_lliterateness
immediateness1862936im__mediateness
imperativeness2155466imper_ativeness
imperfectness2261706imper_fect_ness
impersonates1653896impersonat__e_s
impertinences1953596impertin__ences
impetuousness1754336imp_etu_ousness
importances1754296import__a__nces
importancies1853276import__ancie_s
importations16156146import__at_ions
importune1344776importu____ne__
importuned1542896importu____ne_d
importunely1852456importu____nely
importuner1452686importu____ne_r
importuning1652526importun__in__g
importunity1852446importunit____y
impossibleness2062256impo_ssibleness
impoundments1972436impo__undmen_ts
impreciseness1962706imp_r_eciseness
impregnates1653116imp_regnat__e_s
impressiveness2164466imp_ressiveness
impureness1444066imp___u__reness
inadequateness2471876inadequ_ateness
incorruptness1781816incorru_pt_ness
innateness1046896i_____nnateness
insatiateness1364436i_nsat_iateness
intimateness1455796i___ntimateness
intricateness1564716i_ntr_icateness
irateness9310496i___r___ateness
moderateness1565286_m_o_derateness
obdurateness1553056___obdurateness
obstinateness1562806__obstinateness
opportunenesses1961426opportun__enesses
opportunities1771846opportunit_ie_s
privateness1655706__p_r_ivateness
proximateness2462456__proximateness
separateness1455506separ___ateness
sportiveness1766966_sport__iveness
temperateness1764426temper___ateness
unfortunates1551796unfortunat__e_s

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 Filter178691950240.1261418182.5
2DLD Change Limit95024639.33010184.8
3Display Results63630.0461369.6
 (SQL Overall)178691639.50218805.6
 
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.