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

83 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
inverness124713(None) 
innerness946911innerness
governess1346172governess
inertness947972in_ertness
internees93014842internees
internes82721232interne_s
invernesses1447032invernesses
inverses112410982inverse_s
inverters12239752inverters
angerless1045023angerless
bitterness1245553bitterness
cleverness1543223cleverness
coverless1436803coverless
covertness1545503covertness
dinnerless1152713dinnerless
eagerness1046263eagerness
evenness1135543_evenness
fineness11310643fin_e_ness
governessy1741853governessy
idleness936843idle_ness
inaneness948383inaneness
inaptness1144333inaptness
incenses102411003ince_nses
indenes82916253inde_ne_s
ineptness1145073ineptness
infernos1145903infern_os
inferrers12226583inferrers
ingress838653in_gr_ess
inheres10315173inher_e_s
inkiness1238693in_kiness
innernesses1146733innernesses
innerves1158013innerve_s
inserters92210283inserters
intentness1047363intentness
interbeds12238903interbeds
interest8319183inter_est
interests9312553inter_ests
intermesh1446703intermesh
internals9712723internals
interne73218143interne__
interned93016653interne_d
internee82718513interne_e
internist9414883internist
internists10410243internists
interns73116773intern__s
inventers12269533inventers
inventress1343623inventress
invents102812053inve_n_ts
inverse10249643inver__se
inversed12269283inverse_d
inversely1544983inversely
invertase1245823invertase
invertases1345783invertases
inverted122312163inverte_d
inverter112411073inverte_r
invertins12911023invertins
invertors12239793invertors
inverts103211953inver__ts
inwardness1443773inwardness
levelness1245453levelness
limberness1443273limberness
linerless936333lin_erless
liveness112411393live_ness
mindedness1445143mindedness
nearness838313_nearness
newness1035703_n_ewness
niceness1039843nice_ness
oneness7512143on_e_ness
otherness1245513otherness
overtness1238223_overtness
queerness1844213queerness
riverless1244943riverless
severeness1346123severeness
sheerness1236273sheerness
silveriness1443853silveriness
sincereness1345003sincereness
soberness1186463soberness
taverners1244273taverners
tenderness1145283tenderness
unevenness1343873unevenness
unharness1245253unharness
utterness946223utterness
wilderness1443513wilderness

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 Filter1786911486410.436409841.7
2DLD Change Limit148641836.25323771.1
3Display Results83830.0461804.3
 (SQL Overall)178691836.73526531.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.