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

38 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
hyperventilated2716205(None) 
hyperventilate25212581hyperventilate_
hyperventilates26192211hyperventilates
hyperinflated2562434hyper_in_flated
hyperexcited3063515hyper_exci__ted
hypersensitized3383025hypersensitized
hyperstimulated2692145hyperstimulated
unventilated1653515___unventilated
ventilated1446365_____ventilated
differentiated2272476differ_enti_ated
eventuated14103716___e_vent_uated
herniated1346016h__er__n_i_ated
hypercivilized3772066hyper_civilized
hyperextended3062226hyper_ext_ended
hypersensitive2583526hypersensitive_
hypersensitize3173656hypersensitize_
hypersensitizes32103436hypersensitizes
hyperstimulate2492386hyperstimulate_
hyperstimulates25132206hyperstimulates
hypertensive2354586hypertensi__ve_
hypertensives2463826hypertensi__ves
hypervigilance2871186hyperv_igilance
hypervigilances2971106hyperv_igilances
hypervigilant2591706hyperv_igila_nt
hyphenated2253366hyp__hen___ated
overestimated19144856_over_estimated
percentile1447416__percentil__e_
percentiles1546206__percentil__es
peregrinated1653086__per_egrinated
perennated1345696__per_en__nated
perpetrated1675076__perpe_t_rated
perpetuated1653756__perpe_t_uated
potentiated1494366__p_otenti_ated
predestinated1794196__predestinated
superinsulated1762296super_insulated
underestimated1863036under_estimated
ventilate1248386_____ventilate_
ventilates1347606_____ventilates

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 Filter178691950240.343520965.0
2DLD Change Limit95024387.40612830.7
3Display Results38380.0301266.7
 (SQL Overall)178691387.77922970.9
 
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.