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

57 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
epochal144524(None) 
epical10413392epic_al
epoch1248202epoch__
epochally1943412epochally
epochs1335812epoch_s
trochal1288242trochal
apical10913903apic_al
apodal9289833apo_dal
apogeal1045623apogeal
asocial998653asocial
coccal9310223_coccal
conchal144211583conchal
deposal1037153depo_sal
ecocidal1354963ecocidal
edictal1046993edictal
eparchial1644403eparchial
epha9310053ep__ha_
ephah1337063ep__hah
ephas10311543ep__has
ephoral1248403ephoral
epifocal1543793epifoc_al
epigeal1046243epigeal
eschar1136523e_schar
especial1246293especial
espousal1083013espousal
eusocial1045463eusocial
exarchal2043723exarchal
exposal1645313expo_sal
focal104917673_foc_al
local74820273_loc_al
lochan1139093_lochan
lochial1257083_lochial
mocha1249923_mocha_
mochas13310663_mochas
nuchal11218873_nuchal
octal71214723__octal
pacha126518063_pacha_
pachas135017143_pachas
paschal14157243paschal
pechan13511543_pechan
pedocal1237893pedoc_al
pical95524373_pic_al
pochard1537363_pochard
portal84218463_portal
postal84317533_postal
reposal939113repo_sal
rhonchal1642673rhonchal
social8813333_social
spacial1138763spacial
spathal1236263spathal
special11310303special
sponsal946343sponsal
sporal82915453spo_ral
spousal965533spousal
trochar1257073trochar
trochil1258713trochil
vocal104715643_voc_al

Search took 7 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.1561145455.1
2DLD Change Limit134027576.59320328.7
3Display Results57570.0301900.0
 (SQL Overall)178691576.77926359.5
 
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.