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

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

116 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
heydays173414(None) 
heyday1635141heyday_
heydeys1732861heydeys
bendays13327512bendays
headways1845002headways
heydey1634632heydey_
holydays1843472holydays
keyways2043372keyways
maydays1634482maydays
paydays1634432paydays
anyways1644423anyways
belays114313853be_lays
beldams1237053beldams
benday123810813benday_
bendways1743733bendways
bendys12518383bend_ys
betrays12127823betrays
bewrays15145113bewrays
byways1734673_byways
cedars93312833ce_dars
cheddars15234373cheddars
days87637133___days
decays124612913de_cays
dedans85915073de_dans
deejays1843433deejays
defrays1436113defrays
delays104014053de_lays
deodars937623deodars
derays105514253de_rays
embays131408323_embays
endways1444443_endways
essays965653_essays
everydays1951273everydays
eyas76427433_ey_a_s
eyass84410783_ey_ass
eyras84715923_eyra_s
flyways19133853flyways
gaydars1235803gaydars
hardass1139753hardass
hays106138073h___ays
headers113819393headers
heads95127113he__ads
headstays1643563headstays
headway1745553headway_
heady125117263head_y_
heals85733453he__als
heaps105223223he__aps
hears86737373he__ars
hearsays1444513hearsays
heats85838403he__ats
heddles123311623heddles
heders104119763he_ders
hedges115016243he_dges
hedgy134510743he_dgy_
heeders114213743heeders
heeds95420423heed__s
heehaws1643343heehaws
hendiadys1741663hendiadys
henleys1334843henleys
hennas94211803henna_s
henrys12366103he_nrys
hepcats1436473hepcats
heptads1335873heptads
herbals122710603herbals
herders113914123herders
herdics13249523herdics
herds96424683herd__s
hetmans12187593hetmans
hexades18378703hexades
hexads17468193he_xads
hodads1147963h_odads
holidays1544103holidays
holyday1743773holyday_
hondas10313353honda_s
hoorays13418373hoorays
houdahs1434243houdahs
howdahs1733613howdahs
hoyas115016163hoy_a_s
hoydens14347403hoydens
hurrays13386153hurrays
hydras13239313h_ydras
hydros13279363h_ydros
hyenas1288953hyena_s
hylas114815903h_yla_s
jetways2094053jetways
keddahs1642923keddahs
keypads1743343keypads
keypals1634353keypals
keyway1943823keyway_
khedahs1852953khe_dahs
khedas1446313khe_da_s
leeways1354453leeways
mayday1535873mayday_
medals94218043me_dals
middays14335663middays
naysays1344123naysays
payday1536613payday_
pedals94316033pe_dals
playdays1742973playdays
redans75421023re_dans
redbays1336013redbays
relays94316753re_lays
repays113813973re_pays
replays12399763replays
resays93714153re_says
seaways13307513seaways
sedans74816093se_dans
sendals81912263sendals
serdabs1035323serdabs
skyways2043223skyways
todays10458103_todays
veejays2042313veejays
waylays1634673waylays
weekdays1941433weekdays
whydahs2041883whydahs
yays105728913__y_ays

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.1561145455.1
2DLD Change Limit1340271167.37618170.7
3Display Results1161160.0303866.7
 (SQL Overall)1786911167.56223630.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.