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

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

102 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
dyads1054997(None) 
dads67442771d_ads
deads75726911deads
dryads11436621dryads
duads76515341duads
dyad96415451dyad_
ads49755732__ads
ayahs116813522ayahs
bads77048862_bads
beads85429502beads
brads85528292brads
cads76144522_cads
chads116122232chads
clads85722732clads
cyans105714812cyans
cycads14476212cycads
dabs77139402d_abs
dad58456162d_ad_
dada66422442d_ada
dadas75819862d_adas
dado67126332d_ado
dados75522432d_ados
dags66642602d_ags
dahs88231812d_ahs
dais57040702d_ais
daks97130602d_aks
dals57145122d_als
dams77444372d_ams
dans56748152d_ans
daps77239162d_aps
daws86638242d_aws
days87637132d_ays
dead65434242dead_
deals65435342deals
deans66131392deans
dears65736882dears
deeds75423762deeds
dhaks13479702dhaks
dhals95415442dhals
dials64925342dials
doats65224882doats
drabs85119672drabs
drags75521112drags
drams86025832drams
drats66628372drats
draws95119372draws
drays95819772drays
dreads84115022dreads
dryad10477582dryad_
dryades12395632dryades
duad66521412duad_
duals65620082duals
duds65530142d_uds
dyadic1336092dyadic
dyadics1453472dyadics
dyed96720762dyed_
dyers96617132dyers
dyes85331892dy_es
dykes135215572dykes
dynes95917582dynes
egads74610922egads
eyas76427432eya_s
eyass84410782eyass
fads86939872_fads
gads67843382_gads
glads75620612glads
goads77022852goads
grads75625752grads
heads95127112heads
kyaks11459162kyaks
kyars124813962kyars
kyats125012442kyats
lads56549132_lads
leads66028492leads
loads65323372loads
mads76845372_mads
meads85425322meads
pads76742952_pads
pyas96225702pya_s
quads154515842quads
rads56046602_rads
reads64835272reads
roads66523622roads
ryas77224612rya_s
rynds9569972rynds
scads85419962scads
shads95124482shads
tads57143942_tads
toads65621072toads
wads87343142_wads
woads94818442woads
wynds126310372wynds
yags86632292_yags
yaks116025202_yaks
yams95330732_yams
yaps95933522_yaps
yards95324612_yards
yauds95013222_yauds
yaws105531212_yaws
yays105728912_yays
yids85224962_yids
yods86531182_yods

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001021.50035866.7
3Display Results1021020.0333090.9
 (SQL Overall)1786911021.84396956.6
 
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.