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

50 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
epazote184370(None) 
epazotes1943771epazotes
azote144416342__azote
epidote1037392epidote
epizoite1944142epizoite
apagoge11164683apagoge
apatite9312963apatite
azole145118033__azole
azoted16388593__azoted
azotes154312223__azotes
azoth17389903__azoth
capote10315733_capote
chayote1536493chayote
diazole1736793diazole
ecarte84313503eca_rte
egalite8311563egalite
elate55335883ela__te
emanate9312473emanate
emote75421193e__mote
enate54428153ena__te
endnote855743endnote
epact94921533epa_ct_
epacts105010393epa_cts
epaulet939513epaulet
epidotes1147023epidotes
epigone1057843epigone
epilate9314283epilate
episode1056303episode
episome1157813episome
epitome1157743epitome
epitope1147053epitope
epizoa1745013epizo_a
epizoic2045193epizoic
epizoites2043693epizoites
epizoon1843813epizoon
epizooty2242143epizooty
epode85114093ep__ode
evzone1894683e_vzone
exabyte1943523exabyte
garote7717953_garote
lepidote1144683lepidote
palate84226793_palate
parole84425253_parole
paste74932953_pa_ste
pate65350463_pa__te
peyote1139853_peyote
pozole1758913_pozole
sapote8314363_sapote
separate10310783separate
spate74731583spa__te

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 Filter1786911340270.406440125.6
2DLD Change Limit134027506.79619721.5
3Display Results50500.0163125.0
 (SQL Overall)178691507.21824756.3
 
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.