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 “electrogram” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

54 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
electrogram165488(None) 
electrograms1755051electrograms
spectrogram1852812spectrogram
electoral1156723elect_o_ral
electroform18104033electroform
electromyogram24102303electromyogram
electroweak2063573electroweak
hectogram17115813_hect_ogram
spectrograms1952633spectrograms
aerogram1149524_ae__rogram
dendrogram1563124_dendrogram
deprogram1555914_de_program
echogram1646394__ec_hogram
elector93313254elect_o_r__
electorate1247584elect_o_rate
electors103013844elect_o_r_s
electrical1446144electr_ical
electrician1554484electrician
electro92810034electro____
electrocute1555084electrocute
electrode1247014electro__de
electrodermal1862714electrodermal
electrodes1347254electro_des
electroed1246974electro__ed
electroforms19104184electroforms
electrogenic1755674electrogenic
electroing1346904electro_ing
electrojet1956774electro_jet
electrojets2055254electrojets
electroless1356004electroless
electrology1755224electrology
electrolyte1655634electrolyte
electrolyze2554684electrolyze
electromyograms25102034electromyograms
electron102611414electro___n
electronic1477944electro_nic
electronica1586434electronica
electronicas1675534electronicas
electronics1557214electronics
electrons112411754electro__ns
electroplate1664674electroplate
electros102811744electro___s
electrotype1854624electrotype
electrum1245214elect___rum
ethogram1446354__e_thogram
hectograms18114814_hect_ograms
hektogram1994324_hekt_ogram
microgram1648024_mic_rogram
overprogram1952954overprogram
pictogram1645164_pict_ogram
preprogram1754694pre_program
reprogram1456614_re_program
spectrograph22123524spectrograph
tetragram1244414_te_tragram

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 Filter1786911488190.420425454.8
2DLD Change Limit148819548.76616976.8
3Display Results54540.0331636.4
 (SQL Overall)178691549.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.