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

51 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
electromyograms25102031electromyograms_
electromyogram24102302electromyogram__
electromyograph2881863electromyogra_ph
electrograms1755054electr___ograms_
electroforms19104185electro_fo_r_ms_
electrogram1654885electr___ogram__
electrodynamic24123346electrody__namic
electroform18104036electro_fo_r_m__
electroformed2163116electro_fo_r_med
electrologies1656256electro_log_ies_
electrologist1657046electro_log__ist
electrologists1765646electro_logists_
electromagnets1973286electrom_agnets_
electrometers1765806electrometer__s_
electrophorese21173856electropho_r_ese
electrophorus2063706electropho_r_us_
electrotypers2063636electrotyper__s_
spectrograms1952636spectr___ograms_
chromatograms2392947___chromatograms_
chronograms1953937___chro_nograms_
electrodermal1862717electro__der_mal
electrodynamics25112957electrody__namics
electroforming2272667electro_fo_rming
electrology1755227electro_log____y
electrolyses1755627electroly___ses_
electrolysis1755597electroly___sis_
electrolytes1755937electroly___tes_
electrolyzes2655177electroly___zes_
electromagnet1863927electrom_ag__net
electromagnetic2272837electrom_agnetic
electrometer1656277electrometer____
electronicas1675537electro__nica_s_
electrophoresed23162747electropho_resed
electrophoreses22173187electropho_reses
electrophoresis22163207electropho_resis
electrophoretic24103137electropho_retic
electrophori1964707electropho_r___i
electroscopes19155697electrosco__pes_
electroshocks2493217electrosho__cks_
electrotherapy2482067electro_thera_py
electrothermal2171987electro_ther_mal
electrotonus1453887electro_to__nus_
electrotonuses1662747electro_tonuses_
electrotyper1964067electrotyper____
electrotypes1965187electroty___pes_
hectograms18114817_hect____ograms_
microprograms2263087_mic_roprograms_
plethysmograms27101327ple_thysmograms_
spectrogram1852817spectr___ogram__
thermograms1964487the__r_m_ograms_
tomograms1445897____t_om_ograms_

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.356501941.0
2DLD Change Limit95024518.56311097.0
3Display Results51510.0461108.7
 (SQL Overall)178691518.96519932.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.