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

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

66 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
esterify144562(None) 
etherify1744442etherify
aerify122810113__aerify
alterity1149843alterity
asperity1347223asperity
asteria7316183asteri_a
asterias8317013asterias
asterisk1248673asterisk
asterism10413253asterism
austerity1245813austerity
desertify1643643des_ertify
dexterity2044343dexterity
easterly11246643easter_ly
eateries8324313eateries
eatery95316353eater__y
eerily92913563e__erily
enteric9314213enteri_c
enterics10312853enterics
entering91920053entering
eserine7415903es_erine
esoteric1057593esoteri_c
esoterica1144273esoterica
ester54727713ester___
esterase849483esterase
esterified1445403esterified
esterifies1347153esterifies
esterifying1873693esterifying
esters64627733ester__s
estray95713333est_r_ay
estrin6315923est_ri_n
estrins7315853est_rins
estriol747553est_riol
eternity1146683e_ternity
exterior1547373exterior
festering132413173festering
gentrify1544683gent_rify
metrify1535623met_rify
nitrify1335793nit_rify
pestering122315663pestering
petrify1536573pet_rify
posterity1448693posterity
respecify1943133respecify
reverify1744813reverify
scarify1537443_scarify
scorify1535203_scorify
serif84132133_s_erif_
serifs94017053_s_erifs
severity1446973severity
sherif122915243_sherif_
sheriff16287693_sheriff
sherifs13299683_sherifs
specify1764993_specify
stellify1443883_stellify
steric8317063_steri_c
sterile7316603_sterile
sternly1037853_sternly
strife95318363_st_rife
stripy115812743_st_ripy
terrify1336353__terrify
testify13246943test__ify
verify153110163__verify
vitrify1645003vit_rify
waterily1438783waterily
westering132112643westering
westerly1445553wester_ly
yesterday1642103yesterday

Search took 8 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 Filter1786911461620.500357382.0
2DLD Change Limit146162667.17320376.7
3Display Results66660.0164125.0
 (SQL Overall)178691667.68923239.8
 
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.