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
electronegative2191831electronegative_
electropositive2272355electropositive_
seronegative1652705_se__ronegative_
electrologies1656266electrolog__i_es
electrometer1656286electrome__t__er
electronica1586456electron____i_ca
electroplate1664686electro_plat__e_
electroplated1863896electro_plat__ed
electroplates1764616electro_plat__es
electroplating1963496electro_plati_ng
electrostatic1764056electro_stati__c
electrostatics1863446electro_stati_cs
photonegative2263396_phot_onegative_
decongestive1952397_dec__ongestive_
derogative1546987_de__ro__gative_
detonative1447137_de_t_on__ative_
electioneer1353867electione_____er
electioneered1672157electione___ered
electioneerer1581977electione___erer
electioneering1782137electione_eri_ng
electorate1247607elect_o__rat__e_
electorates1347487elect_o__rat__es
electricities1755237electr__iciti_es
electrification2263417electrificati_on
electroanalyses2092767electro_analyses
electrocute1555097electro__cut__e_
electrocuted1754187electro__cut__ed
electrocutes1655317electro__cut__es
electrocuting1863597electro__cuti_ng
electrocution1763397electro__cuti_on
electrocutions1863027electro__cutions
electrodeposit19223027electrodeposi__t
electrodeposits20212517electrodeposi_ts
electrodialyses2182677electro_dialyses
electrodynamic24123357electrodynami__c
electrodynamics25112967electrodynami_cs
electrogeneses1764537electro__geneses
electrogenesis1764487electrogenesi__s
electrogenic1755687electro__geni__c
electrojet1956807electroje__t____
electrojets2055267electroje__t___s
electrokinetic22123477electrokineti__c
electrokinetics23122977electrokineti_cs
electrologist1657057electrolog__i_st
electrologists1765657electrolog__ists
electrolyte1655647electro__lyt__e_
electrolytes1755947electro__lyt__es
electrolytic1955777electro__lyti__c
electromagnet1863937electro__ma_gnet
electromagnetic2272847electromagneti__c
electrometers1765817electrome__t_ers
electronic1477957electron____i__c
electronically2163837electronica__lly
electronicas1675547electron____icas
electronics1557227electron____i_cs
electroosmotic2072567electroosmoti__c
electrophile1955347electro___phile_
electrophiles2055127electro___philes
electrotype1854637electro____type_
electrotyped2064047electro____typed
electrotyper1964077electro____typer
electrotypes1965197electro____types
electroweak2063607electrowe_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 Limit95024729.26310258.4
3Display Results72720.0461565.2
 (SQL Overall)178691729.66918480.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.