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

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

31 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
oversensitivity2471341oversensitivity_
oversensitive1963464oversensitiv___e
insensitivity1962745__insensitivity_
sensitivity1753815____sensitivity_
intransitivity2062376intr_ansitivity_
overactivity23103976over___activity_
seropositivity2291176_seropositivity_
transitivity1854046__tr_ansitivity_
defensibility2254457_de_fensibility_
desensitizing2462947_de_sensitizi_ng
extensibility2553907__extensibility_
hypersensitive2583527hypersensitiv___e
insensibility1875917__insensibility_
insensitively1953547__insensitively_
insensitivities1882717__insensitivities
overestimate1775197over_e_s_timat_e
overestimated19144857over_e_s_timated
overestimates1854867over_e_s_timates
overgenerosity2171647overgen_erosity_
overstability21125377overs__tability_
perceptivity2453427_perce__ptivity_
perfectivity2563847_perfe__ctivity_
resensitizing2353437_re_sensitizi_ng
resistivity1773787___r_e_sistivity_
retentivity1754177_re_ten__tivity_
sensibility1646907____sensibility_
sensitively1754997____sensitively_
sensitivities1654537____sensitivities
seronegativity2171097_seronegativity_
supersensitive1962787supersensitiv___e
versatility1755137_ver___satility_

Search took 9 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.360496363.9
2DLD Change Limit95024318.28011476.3
3Display Results31310.0161937.5
 (SQL Overall)178691318.65620643.6
 
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.