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

33 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
hysterectomized35111651hysterectomized_
hysterectomies24122383hysterectomi_e_s
hysterectomy2561995hysterectom____y
hysterotomies2162435hyster_otomi_e_s
gastrectomies1863786gast_rectomi_e_s
hepatectomized3372016h_epatectomized_
nephrectomized3372216_nephrectomized_
splenectomized3072276_splenectomized_
thymectomized3561936thy___mectomized_
vasectomized2962826vas___ectomized_
clitorectomies2081917clitorectomi_e_s
gonadectomized3071887_gonadectomized_
historicized2782247historic___ized_
hyperbolized3254137hy_per__bolized_
hysteretic1853977hystere_t__i___c
hysteroid1645897hyster___o_i__d_
hysterotomy2262147hyster_otom____y
laryngectomized3381477laryngectomized_
mastectomies1854017mast__ectomi_e_s
nephrectomize3172337_nephrectomize__
nephrectomizes3272647_nephrectomize_s
ovariectomized3171947_ovariectomized_
pinealectomized31172327pinealectomized_
skeletonized2662307__skele_tonized_
splenectomize2872407_splenectomize__
splenectomizes2972607_splenectomize_s
systematized2773667syste_mat__ized_
systemized2554137syst__e___mized_
thymectomize3362037thy___mectomize__
thymectomizes3462387thy___mectomize_s
vasectomize2762927vas___ectomize__
vasectomizes2853387vas___ectomize_s
vitrectomies1963477_vit_rectomi_e_s

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 Limit95024338.33011407.4
3Display Results33330.0301100.0
 (SQL Overall)178691338.72020492.1
 
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.