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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
esterifying187369(None) 
etherifying2152842etherifying
aerifying1636493__aerifying
asterisking1652973asterisking
desertifying2092873des_ertifying
esterified1445403esterif_ied
esterifies1347153esterif_ies
esterify1445623esterify___
estraying1338293est_r_aying
gentrifying1943813gent_rifying
metrifying1945683met_rifying
nitrifying1744783nit_rifying
petrifying1945823pet_rifying
respecifying2372553respecifying
reverifying2143853reverifying
scarifying1945013_scarifying
scorifying1944473_scorifying
specifying2144683_specifying
stellifying1842713_stellifying
terrifying1745163__terrifying
testifying1745403test__ifying
verifying1936413__verifying
vitrifying2044173vit_rifying
acetifying1944454_acetifying
astricting1357834ast_ricting
astringing1245774ast_ringing
beatifying1945734beat__ifying
bestriding1446004best_ri_ding
certifying1945314__certifying
citifying1845384cit__ifying
clarifying1944854_clarifying
copurifying2252754copurifying
decertifying2292794decertifying
deifying1637634__de_ifying
denitrifying2062664denitrifying
destroying1564904dest_r_oying
detoxifying2652634detoxifying
devitrifying2352184devitrifying
diversifying2352164diversifying
edifying1636084___edifying
electrifying2153444electrifying
emulsifying2052434emulsifying
enserfing1345894enser_f_ing
entering91920054enter___ing
esteeming1244704este__eming
estranging1246024est_ranging
estreating11710364est_reating
eternising1146004e_ternising
eternizing2046764e_ternizing
etherizing2346854etheri_zing
extermining2154044extermining
festering132413174fester___ing
glorifying1843674_glorifying
horrifying2043984_horrifying
intensifying1982564intensifying
interfiling1546954interfiling
interlaying1547574interlaying
introfying1744854int_rofying
justifying2444054just__ifying
laterizing2049104lateri_zing
lithifying2073644lit_hifying
mesmerising1643934mesmeri_sing
mesmerizing2544874mesmeri_zing
micrifying2144814_micrifying
mystifying2243944myst__ifying
nigrifying1843844_nigrifying
notifying1645624not__ifying
ossifying1644254os__sifying
pestering122315664pester___ing
prespecifying2651874prespecifying
prettifying2044004prettifying
purifying1835854__purifying
putrefying1942954put_refying
rarifying1646314__rarifying
ratifying1656824rat__ifying
recertifying2183234recertifying
rectifying1946374rect__ifying
reedifying1845244_reedifying
reglorifying2052044reglorifying
reifying1539384__re_ifying
repurifying2043934repurifying
resinifying1844354res_inifying
restricting1449304rest_ricting
restriking1548044rest_ri_king
restringing1345714rest_ringing
restriving1448134rest_ri_ving
retestifying1993414retestifying
salifying1636334_s_alifying
seriating10916404_s_eriating
serrying12167704_s_er_rying
signifying1844414_signifying
steadying14154504_ste_adying
stereoing1037894_ster_eoing
sterilising1245024_sterilising
sterilizing2146904_sterilizing
sterling93615554_ster__ling
stiffing15248704_st__iffing
stifling122110914_st__ifling
stimying1437504_st__imying
storying12249674_stor__ying
strafing122111194_st_raf_ing
stratifying1843524_stratifying
straying122912694_st_r_aying
striating10914194_st_riating
striding102713604_st_ri_ding
striking133012234_st_ri_king
stringing1139754_st_ringing
striping112612524_st_ri_ping
stripling1257784_st_ripling
stripping1436494_st_ripping
striving122611394_st_ri_ving
stroying122410594_st_r_oying
stultifying1852344_stultifying
stupefying1942014_stupefying
tariffing1644114__tariffing
tepefying1843234__tepefying
torrifying1744174_torrifying
trifling122411504__t_rifling
typifying2143324__typifying
unedifying1843724_unedifying
verbifying2244354__verbifying
versifying2045034__versifying
westering132112644wester___ing
westernising1653064westernising
westernizing2553724westernizing

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.436409841.7
2DLD Change Limit1488191259.39315843.6
3Display Results1251250.0761644.7
 (SQL Overall)1786911259.90518040.5
 
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.