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

111 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
treads7481792(None) 
breads95419201breads
dreads84115021dreads
oreads73915771oreads
reads64835271_reads
threads11419951threads
tread64821701tread_
treats64821691treats
trends75513541trends
triads74513531triads
areas55935772area_s
beads85429502_beads
brads85528292br_ads
bread85523112bread_
bready124511182bready
breaks124816422breaks
breams104815042breams
breeds94914882breeds
broads94515152broads
creaks124315962creaks
creams104715252creams
creds85418772cre_ds
creeds94714772creeds
deads75726912_deads
dread74419022dread_
dreams94513982dreams
drears74614252drears
dryads11436622dryads
freaks134713062freaks
grads75625752gr_ads
greats76318392greats
greeds84314282greeds
heads95127112_heads
kneads11357092kneads
leads66028492_leads
meads85425322_meads
oread64619602oread_
outreads9289002outreads
pleads94613952pleads
rads56046602_r_ads
read55942532_read_
readd74617132_readd
readds84111642_readds
ready94821502_ready
reals55038652_reals
reams75729622_reams
reaps75626192_reaps
rears54739652_rears
redds74617832_redds
reds56042862_re_ds
reeds65430902_reeds
rends65129952_rends
rereads81512292rereads
retreads937822retreads
roads66523622_roads
spreads1039762spreads
steads74116222steads
streaks114411272streaks
streams94713372streams
tads57143942t__ads
teaks94222902t_eaks
teals56234132t_eals
teams75726512t_eams
tears55436462t_ears
teas45851492t_ea_s
teats55636812t_eats
teds54932572t_e_ds
tends65425582t_ends
terais64023512terais
thread105011092thread_
thready14435902thready
threaps12488642threaps
threats104311672threats
toads65621072t_oads
toeas55726422toea_s
trad55630912tr_ad_
trade65026042tr_ade
trades75724502tr_ades
trams75327672tr_ams
trans54933042tr_ans
traps75727482tr_aps
trass56226472tr_ass
trays85623432tr_ays
treaded95014282treaded
treader84113832treader
treaders93311842treaders
treadle8310102treadle
treadles939702treadles
treat56240352trea_t
treaty94414352treaty
treed65626732treed_
treens65317872treens
trees55835762tre_es
treks96016852tre_ks
trend64817452trend_
trendy10469602trendy
trepans92311592trepans
tres46542902tre__s
tress55423162tre_ss
trets55928022tre_ts
trews86118892tre_ws
treys85018212tre_ys
triacs83913222triacs
triad65217722triad_
trials64319882trials
troaks104410602troaks
tweaks1335962tweaks
tweeds10498432tweeds
untreads936222untreads
ureas55826012urea_s
wreaks134711112wreaks

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511112.47033421.5
3Display Results1111110.0303700.0
 (SQL Overall)1786911112.84362853.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.