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
electromyograms25102041electromyograms_
electromyogram24102312electromyogram__
electromyograph2881873electromyogra_ph
electrograms1755064electr___ograms_
electroforms19104195electro_fo_r_ms_
electrogram1654895electr___ogram__
electrodynamic24123356electrody__namic
electroform18104046electro_fo_r_m__
electroformed2163126electro_fo_r_med
electrologies1656266electro_log_ies_
electrologist1657056electro_log__ist
electrologists1765656electro_logists_
electromagnets1973296electrom_agnets_
electrometers1765816electrometer__s_
electrophorese21173866electropho_r_ese
electrophorus2063716electropho_r_us_
electrotypers2063646electrotyper__s_
spectrograms1952636spectr___ograms_
chromatograms2392947___chromatograms_
chronograms1953937___chro_nograms_
electrodermal1862727electro__der_mal
electrodynamics25112967electrody__namics
electroforming2272677electro_fo_rming
electrology1755237electro_log____y
electrolyses1755637electroly___ses_
electrolysis1755607electroly___sis_
electrolytes1755947electroly___tes_
electrolyzes2655187electroly___zes_
electromagnet1863937electrom_ag__net
electromagnetic2272847electrom_agnetic
electrometer1656287electrometer____
electronicas1675547electro__nica_s_
electrophoresed23162757electropho_resed
electrophoreses22173197electropho_reses
electrophoresis22163217electropho_resis
electrophoretic24103147electropho_retic
electrophori1964717electropho_r___i
electroscopes19155707electrosco__pes_
electroshocks2493227electrosho__cks_
electrotherapy2482077electro_thera_py
electrothermal2171997electro_ther_mal
electrotonus1453897electro_to__nus_
electrotonuses1662757electro_tonuses_
electrotyper1964077electrotyper____
electrotypes1965197electroty___pes_
hectograms18114817_hect____ograms_
microprograms2263087_mic_roprograms_
plethysmograms27101327ple_thysmograms_
spectrogram1852817spectr___ogram__
thermograms1964487the__r_m_ograms_
tomograms1445907____t_om_ograms_

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 Filter178691950240.686260482.5
2DLD Change Limit95024518.50011179.3
3Display Results51510.0331545.5
 (SQL Overall)178691519.21919382.9
 
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.