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

65 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
metastasizing256183(None) 
metastasize2292373metastasiz__e
metastasized24101883metastasiz_ed
metastasizes23152073metastasiz_es
fantasizing2445374__fantasizing
metabolizing2653864meta_bolizing
metalizing22511364me___talizing
metallizing2345754meta__llizing
metastability2055574metastability
metastasis1254244metastas__i_s
tantalizing2158074__tantalizing
apostatizing2453845_apostatizing
bastardizing2552765__bastardizing
bestializing2456165be__stializing
crystalizing2785495_crystalizing
desacralizing2653875desacralizing
destaining1267945de__sta_ining
detasseling1362205detas__seling
detribalizing2654015detribalizing
devastating1644705devasta__ting
devitalizing2645945de_vitalizing
empathizing2852805empa_t_hizing
emphasizing2853405_e_mphasizing
eternalizing2256245_eternalizing
fantasising1554215__fantasising
fetishizing2752555fetis__hizing
gelatinizing2354055gela_tinizing
hepatizing2546825hepa_t__izing
hypostatizing31102445hypostatizing
italianizing2253335_italianizing
keratinizing2654045kera_tinizing
macadamizing2951945maca_damizing
martyrizing2663665m__artyrizing
materializing2595975materializing
mathematizing3053295mathematizing
mechanizing2846105me__chanizing
mediatizing2445745me__diatizing
melanizing2247855me___lanizing
memorializing2764815memorializing
mesmerizing2544875me__smerizing
metalising1348945me___talising
metastases1244545metastas___es
metastatic1455225metasta__ti_c
methodizing2754965met__hodizing
metricizing2545175met__ricizing
militarizing2464495m_ilitarizing
moisturizing2452625m_oisturizing
mutualizing2345495mut__ualizing
nasalizing2047065__nas_alizing
palatalizing2454895pala_talizing
plasticizing2653915_plasticizing
reassailing1244105re_assa_iling
reattaining1244595re_atta_ining
rebaptizing2543715rebapt__izing
recanalizing2446805reca_nalizing
recapitalizing2863665recapitalizing
reemphasizing3061915reemphasizing
relativizing2553945rela_tivizing
retasting102513415retast____ing
revitalizing2546625re_vitalizing
sectarianizing2662345sectarianizing
sensualizing2254905se_nsualizing
tantalising1246205__tantalising
tetanizing2068095__t_etanizing
totalizing2079225__t_otalizing

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 Filter1786911247900.390458182.1
2DLD Change Limit124790658.37614898.5
3Display Results65650.0431511.6
 (SQL Overall)178691658.80920285.0
 
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.