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

143 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
paydays163443(None) 
maydays1634491maydays
payday1536611payday_
playdays1742971playdays
gaydars1235802gaydars
heydays1734142heydays
mayday1535882mayday_
naysays1344122naysays
pandas95521962panda_s
pardahs13289672pardahs
parlays123910452parlays
playday1643822playday_
waylays1634672waylays
allays94313743_allays
always12409133_always
anyways1644423anyways
arrays95311683_arrays
assays977903_assays
audads8167103_audads
ayahs116813523_ay_ahs
badass949293ba_dass
bandas95120543banda_s
bendays13327513bendays
byways1734673_byways
caymans14349513caymans
dadas75819863da_da_s
days87637133___days
faradays1544273faradays
flyways19133853flyways
gamays126310913ga_mays
gayals1039513gay_als
gaydar1135503gayda_r
hardass1139753hardass
heyday1635143heyday_
heydeys1732863heydeys
holydays1843473holydays
kayaks1236333kay_aks
keyways2043373keyways
landaus8310343landaus
layaways1743403layaways
madams11310943ma_dams
margays1337493margays
mayas105924383may_a_s
middays14335663middays
nadas66320813na_da_s
naysay1234973naysay_
pacas96029403pa_ca_s
pachas135017143pacha_s
padauk1335643pa_dauk
padauks1443943pa_dauks
padders113312873padders
paddies113715723paddies
paddles113515643paddles
paddy125913593pa_ddy_
padis86227143pa_d_is
padles95221123pa_dles
padnags1135083padnags
padres95016983pa_dres
pads76742953pa_d__s
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
pagodas11367553pagoda_s
paisans93614753paisans
paisas84317493paisa_s
palais8420423pa_lais
paleways1645833paleways
pampas124913993pampa_s
panadas103312213panadas
panda85022613panda__
pandani1039903pandani
pandanus1136433pandanus
panders103423733panders
pandies104224503pandies
pandits103914213pandits
pandy115021173pand_y_
pangas99921103panga_s
papadams15104783papadams
papas94927493pa_pa_s
papaws13419113pa_paws
papaya1337503pa_paya
papayas1437273pa_payas
parades104121463parades
parados103816053parados
paras76143043pa_ra_s
pardah123412823parda_h
pardons103817623pardons
pards85634333pard__s
pardy115523953pard_y_
pariahs123812343pariahs
parians93519733parians
parkas125018023parka_s
parkways2043973parkways
parlay113713993parlay_
parleys125212373parleys
parrals94414573parrals
partans94418283partans
pascals11610013pascals
pashas115117063pasha_s
pastas85422873pasta_s
pathways1944273pathways
pavans115715593pa_vans
pawpaws1732823pawpaws
payback2056453payback
paybacks2145493paybacks
payees114812903pay_ees
payers114621823pay_ers
payloads1445293payloads
paynims1434973paynims
payoffs1843243payoffs
payolas12148973payolas
payors114312643pay_ors
payouts1247303payouts
pays95940223p___ays
pedals94316033p_edals
playas114612283play_a_s
playboys1843653playboys
playdate1465263playdate
playdates1554903playdates
plays106320773p__lays
prays105022433p__rays
prepays1437483prepays
psywars1533673psywars
purdahs13285483purdahs
purdas92612263purda_s
pyas96225703p_y_a_s
pyrans11411063p_yrans
radars71314673ra_dars
randans8313213randans
rayahs12579193ray_ahs
rayas85922053ray_a_s
sandals82715203sandals
sardars83112903sardars
sashays1336333sashays
satays94411683sa_tays
skyways2043223skyways
todays10458103_todays
vandals113211663vandals
vandas103915993vanda_s
washdays1842863washdays
waylay1535453waylay_
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.436409841.7
2DLD Change Limit1340271436.70319995.1
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.18524870.0
 
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.