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

39 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
hypothecating276253(None) 
hypothecation26152912hypothecation
hypothecations27132572hypothecations
hyphenating2353713hyp__henating
hypothecate2463593hypothecat__e
hypothecated2672743hypothecat_ed
hypothecates2573503hypothecat_es
hypothecator2562053hypothecat_or
hypothecators2661983hypothecators
hypothesizing3462443hypothesizing
apothecaries1952705_apothecaries
cathecting1844835__cathec_ting
deprecating1777285dep__recating
halogenating1752525halo_genating
hydrogenating2262955hydrogenating
hyphenation22123955hyp__henation
hyphenations2393525hyp__henations
hyphening2144135hyp__he__ning
hypnotherapies2773265hypnotherapies
hypnotherapist27103275hypnotherapist
hypotactic2275455hypot_ac_ti_c
hypothalami2493065hypothalami__
hypothalamic2783175hypothalami_c
hypothec2144295hypothec_____
hypothecs2244135hypothec____s
hypothermia2455235hypothe_rmi_a
hypothermias2554835hypothe_rmias
hypothermic2655095hypothe_rmi_c
hypothesis2157255hypothe__si_s
hypothesize3154185hypothe__size
hypothetical2554585hypothe__tical
imprecating1844905imp__recating
pollenating1444555__pollenating
pothering151911285__pothe__ring
pothunting1643655__poth_unting
preheating16310725__prehe_ating
protecting151910215_prot_ec_ting
superheating18126515superhe_ating
typecasting1951965typ___ecasting

Search took 10 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 Filter1786911247900.1561145455.1
2DLD Change Limit124790398.95313938.3
3Display Results39390.0331181.8
 (SQL Overall)178691399.14219546.2
 
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.