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 “innerness” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
innerness94691(None) 
inverness1247131inverness
dinnerless1152712dinnerless
inaneness948382inane_ness
inertness947972i_nertness
innernesses1146732innernesses
innerves1158012innerve_s
internees93014842internees
internes82721232interne_s
angerless1045023angerless
bitterness1245553bitterness
doneness9411513done_ness
eagerness1046263eagerness
fineness11310643fine_ness
goneness9310763gone_ness
governess1346173governess
idleness936843idle_ness
inaptness1144333inaptness
incenses102411003ince_nses
indenes82916253inde_ne_s
ineptness1145073ineptness
infernos1145903infern_os
inferrers12226583inferrers
ingress838653i_ngr_ess
inheres10315173inher_e_s
inkiness1238693i_nkiness
innateness1046893innateness
innermost1144583innermost
innermosts1242933innermosts
inners63919353inner___s
innerve1056743innerve__
innerved1246293innerve_d
innless7288293inn__less
insaneness1046493insane_ness
inserters92210283inserters
intentness1047363intentness
interbeds12238903interbeds
interest8319183inter_est
interests9312553inter_ests
intermesh1446703intermesh
internals9712723internals
interne73218143interne__
interned93016653interne_d
internee82718513interne_e
internist9414883internist
internists10410243internists
interns73116773intern__s
invernesses1447033invernesses
inverses112410983inverse_s
inverters12239753inverters
inwardness1443773inwardness
limberness1443273limberness
linerless936333linerless
loneness8512093lone_ness
mannerless1243523mannerless
mindedness1445143mindedness
nearness838313_nearness
newness1035703__newness
niceness1039843nice_ness
oneness7512143_one_ness
orneriness1045443orneriness
otherness1245513otherness
queerness1844213queerness
saneness82313723sane_ness
sheerness1236273sheerness
sincereness1345003sincereness
soberness1186463soberness
tenderness1145283tenderness
tinniness936093tinn_iness
unharness1245253unharness
unnerves1157273unnerve_s
utterness946223utterness
wilderness1443513wilderness

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641737.64019455.6
3Display Results73730.0461587.0
 (SQL Overall)178691737.84222786.4
 
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.