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

40 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
illiterateness147261(None) 
literateness1256402__literateness
deliberateness1792683deliberateness
illiberalness1561893illibera_lness
illiterates11115653illiterat__e_s
alliterates11106254alliterat__e_s
illiteracies1453304illitera_cie_s
illiterate10125894illiterat__e__
illiterately1552304illiterat__ely
immoderateness1982584immoderateness
literalness1145494__litera_lness
literariness1253994__literariness
literatenesses1464784__literatenesses
aliterates101510755_aliterat__e_s
alliterate1086625alliterat__e__
alliterated1294695alliterat__e_d
alliterating1354275alliteratin__g
alliterations1384555alliterat_ions
alliterative1553875alliterative__
alliteratively2062045alliteratively
considerateness1872135considerateness
degenerateness1662675degenerateness
desperateness1665195_desperateness
elaborateness1562405_elaborateness
illiberalnesses1791555illiberalnesses
illimitableness1972585illimitableness
inalterableness17153405inalterableness
insatiateness1364435insat_iateness
intemperateness1972735intemperateness
intimateness1455795i__ntimateness
inviolateness1693205invi_olateness
irateness9310495___i__rateness
liberalness1354515__libera_lness
literates91415655__literat__e_s
literatures1183655__literature_s
moderateness1565285__moderateness
obliterates1345125obliterat__e_s
regenerateness1562605regenerateness
temperateness1764425_temperateness
ultimateness1453625_ul_timateness

Search took 7 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.343520965.0
2DLD Change Limit95024406.53314545.2
3Display Results40400.0301333.3
 (SQL Overall)178691406.90625874.7
 
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.