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

53 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
electrifying215343(None) 
electrified1754593electrif_ied
electrifies1645733electrif_ies
electrify1744673electrify___
electroing1346893electr__oing
electrolyzing2863663electrolyzing
electrotyping2163383electrotyping
gentrifying1943813_gentrifying
metrifying1945673_me_trifying
petrifying1945823_pe_trifying
rectifying1946373_rect_ifying
acetifying1944454ace_t_ifying
aerifying1636494_ae__rifying
beatifying1945734_beat_ifying
certifying1945314_cert_ifying
clarifying1944854cl__arifying
decertifying2292794_decertifying
denitrifying2062664denitrifying
desertifying2092874desert_ifying
devitrifying2352184devitrifying
electing112113784elect____ing
electrician1554474electri_cian
electricians1653874electricians
electricity1854944electri_city
electrocuting1863574electrocuting
electrofishing2362414electrofishing
electroforming2272634electroforming
electrowinning2082204electrowinning
elutriating1245074el_utriating
esterifying1873694e_sterifying
etherifying2152844e_therifying
exemplifying3051514exemplifying
fructifying2352374fruct_ifying
glorifying1843674gl__orifying
identifying1943494ident_ifying
lithifying2073644_l_ithifying
micrifying2144814_mic_rifying
nitrifying1744784__nitrifying
objectifying3051694object_ifying
prettifying2044004pre_ttifying
recertifying2183234_recertifying
recodifying2144264_recodifying
repurifying2043934_repurifying
retestifying1993414retest_ifying
reverifying2143854_reverifying
sanctifying2043284sanct_ifying
scarifying1945014__scarifying
scorifying1944474__scorifying
specifying2144684spec__ifying
terrifying1745154_te_rrifying
testifying1745404_test_ifying
verifying1936414_ve__rifying
vitrifying2044174__vitrifying

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790538.68614366.8
3Display Results53530.080662.5
 (SQL Overall)178691538.90620064.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.