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

72 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
electronegative2191821electronegative_
electropositive2272345electropositive_
seronegative1652695_se__ronegative_
electrologies1656256electrolog__i_es
electrometer1656276electrome__t__er
electronica1586446electron____i_ca
electroplate1664676electro_plat__e_
electroplated1863886electro_plat__ed
electroplates1764606electro_plat__es
electroplating1963486electro_plati_ng
electrostatic1764046electro_stati__c
electrostatics1863436electro_stati_cs
photonegative2263396_phot_onegative_
decongestive1952397_dec__ongestive_
derogative1546987_de__ro__gative_
detonative1447137_de_t_on__ative_
electioneer1353867electione_____er
electioneered1672147electione___ered
electioneerer1581967electione___erer
electioneering1782127electione_eri_ng
electorate1247607elect_o__rat__e_
electorates1347477elect_o__rat__es
electricities1755227electr__iciti_es
electrification2263417electrificati_on
electroanalyses2092757electro_analyses
electrocute1555087electro__cut__e_
electrocuted1754177electro__cut__ed
electrocutes1655307electro__cut__es
electrocuting1863587electro__cuti_ng
electrocution1763387electro__cuti_on
electrocutions1863017electro__cutions
electrodeposit19223017electrodeposi__t
electrodeposits20212507electrodeposi_ts
electrodialyses2182667electro_dialyses
electrodynamic24123347electrodynami__c
electrodynamics25112957electrodynami_cs
electrogeneses1764527electro__geneses
electrogenesis1764477electrogenesi__s
electrogenic1755677electro__geni__c
electrojet1956787electroje__t____
electrojets2055257electroje__t___s
electrokinetic22123467electrokineti__c
electrokinetics23122967electrokineti_cs
electrologist1657047electrolog__i_st
electrologists1765647electrolog__ists
electrolyte1655637electro__lyt__e_
electrolytes1755937electro__lyt__es
electrolytic1955767electro__lyti__c
electromagnet1863927electro__ma_gnet
electromagnetic2272837electromagneti__c
electrometers1765807electrome__t_ers
electronic1477947electron____i__c
electronically2163837electronica__lly
electronicas1675537electron____icas
electronics1557217electron____i_cs
electroosmotic2072557electroosmoti__c
electrophile1955337electro___phile_
electrophiles2055117electro___philes
electrotype1854627electro____type_
electrotyped2064037electro____typed
electrotyper1964067electro____typer
electrotypes1965187electro____types
electroweak2063587electrowe_a____k
execrative2246047exec_r____ative_
exonerative2155397__e__xonerative_
lectionaries1454777_lection__ari_es
prerogative1755357pre__ro__gative_
prerogatived1952637pre__ro__gatived
prerogatives1853437pre__ro__gatives
recreative1549027_rec_r__e_ative_
segregative1654067_se_gr__egative_
seronegativity2171097_se__ronegativity

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.360496363.9
2DLD Change Limit95024728.65610977.8
3Display Results72720.0461565.2
 (SQL Overall)178691729.06219718.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.