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

41 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
electrosurgical207171(None) 
electrochemical2372724electrochemical
electrosurgery2071794electrosurg_ery
microsurgical2062464_mic_rosurgical
neurosurgical1661834_ne_urosurgical
chemosurgical2361375che__mosurgical
cryosurgical2061345___cryosurgical
electrical1446145elect____r_ical
electrodermal1862715electroder__mal
electronica1586435electro___nica_
electronicas1675535electro___nicas
electrostatic1764045electrostatic__
electrostatics1863435electrostatic_s
psychosurgical2772305psyc_hosurgical
electoral1156726elect_o__r___al
electrocuting1863586electrocu_ti_ng
electrocution1763386electrocu_ti_on
electrocutions1863016electrocu_tions
electroforming2272666electroformi_ng
electrogenic1755676electro_genic__
electrogram1654886electro___g_ram
electrologies1656256electro_logi_es
electrologist1657046electro_logi_st
electrologists1765646electro_logists
electrolytic1955766electro_lytic__
electromyogram24102306electromyog_ram
electronic1477946electro___nic__
electronically2163836electro___nically
electronics1557216electro___nic_s
electroosmotic2072556electroosmotic__
electrophilic2284206electrophilic__
electroshock2383236electros__hoc_k
electroshocks2493216electros__hocks
electrothermal2171986electro_thermal
electrotonic1654906electro_tonic__
liturgical1352116_l_it___urgical
metallurgical1871536_me_tallurgical
metrological1748376_me_tro_logical
necrological1747286_nec_ro_logical
petrological1758596_pe_tro_logical
postsurgical1761506_post__surgical

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.453394461.4
2DLD Change Limit95024417.89012043.6
3Display Results41410.0331242.4
 (SQL Overall)178691418.37621333.7
 
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.