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

205 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
treed6562673(None) 
breed85526691breed
creed85727391creed
dreed75222841dreed
freed95223541freed
greed75125691greed
preed85128121preed
reed55549621_reed
teed55439261t_eed
tread64821701tread
tree47745811tree_
treen55622751treen
trees55835761trees
trend64817451trend
tried65026911tried
trued65117691trued
tweed94915091tweed
agreed84712502agreed
arced88224162arced
armed86324432armed
bleed85019802bleed
bread85523112bread
bred75130972br_ed
brede85520502brede
bree67241262bree_
breeds94914882breeds
brees75632552brees
brewed125411872brewed
cered85227442cered
cred76530882cr_ed
creeds94714772creeds
creek114917392creek
creel75121482creel
creep95218102creep
creped114115712creped
crewed125316562crewed
cried84624292cried
deed65340902_deed
dread74419022dread
dree56638322dree_
drees65628522drees
dried75321382dried
erred65915672erred
feed84538902_feed
free75940182free_
freer86021242freer
frees86131392frees
fremd115010322fremd
fried95322912fried
geed65435502_geed
gleed75320572gleed
gree56641562gree_
greeds84314282greeds
greedy11518852greedy
greek105915942greek
green65522142green
grees65132472grees
greet65835322greet
greyed114610602greyed
heed86437602_heed
ired55131872ir_ed
irked104510922irked
jeed125428502_jeed
jereed144012072jereed
kneed104612052kneed
kreep114610412kreep
meed74934702_meed
need54934152_need
orbed85516192orbed
oread64619602oread
peed76239182_peed
pree67044732pree_
preen75925052preen
prees75937172prees
premed114617762premed
preyed125313202preyed
pried84426862pried
pureed95017812pureed
read55942532_read
red46755802_r_ed
redd66323172_redd
rede55037672_rede
reded74829122_reded
ree37974072_ree_
reeds65430902_reeds
reedy910020292_reedy
reef74938212_reef
reek85232522_reek
reel45240532_reel
rees45364192_rees
refed93921922_refed
rend56136572_rend
rewed95425452_rewed
rued55729792_rued
screed95718932screed
seed55549482_seed
sered65737292sered
skeed105018982skeed
speed85526622speed
steed66024942steed
streek104111412streek
streel64214022streel
street64125772street
strewed115811342strewed
tamed85528512tamed
taped85327422taped
tared69340052tared
tarred74720282tarred
tarted74923372tarted
tarweed1137342tarweed
tawed95926192tawed
taxed135620292taxed
ted46446562t__ed
tee38366872t_ee_
teel46335802t_eel
teem66132602t_eem
teemed95114872teemed
teen45938202t_een
tees45353582t_ees
tend56433772t_end
teredo7310782teredo
termed94816702termed
tewed94718532tewed
thee78039062thee_
themed125912582themed
thread105011092thread
three87526912three_
threep115910112threep
threes97117322threes
tided76322512tided
tied55535212t_ied
tiered73613972tiered
tiled64832942tiled
timed85223612timed
tined65434532tined
tired65228902tired
tirled74714362tirled
toed56137042t_oed
toked105626492toked
toled65934922toled
toned65435342toned
toped85631312toped
toted64929482toted
towed95134582towed
toyed96019802toyed
traced94821582traced
trad55630912tr_ad
trade65026042trade
traded85717682traded
treaded95014282treaded
treads74817922treads
treat56240352treat
treated83618702treated
trebled1038482trebled
treens65317872treens
tref77030992tr_ef
trek86222312tr_ek
trekked1134342trekked
treks96016852treks
trended94011762trended
trends75513542trends
trendy10469602trendy
trepid9310082trepid
tres46542902tr_es
tress55423162tress
tressed83714262tressed
tret46653532tr_et
trets55928022trets
trevet94818912trevet
trews86118892trews
trey77228792tr_ey
treys85018212treys
triad65217722triad
triced95518672triced
trier54328532trier
tries55742812tries
trined74920712trined
trod57627952tr_od
trode65322852trode
troked114114582troked
trowed104714652trowed
truced95312052truced
true46725852true_
truer54916642truer
trues54925322trues
tsked105910032tsked
tubed85818042tubed
tuned64622312tuned
tureen63312722tureen
turfed103110962turfed
turned73914472turned
twee76827082twee_
tweeds10498432tweeds
tweedy13455932tweedy
tween84413742tween
tweet84823982tweet
tyee75131422tyee_
tyees86019452tyees
tyned95915012tyned
typed115815452typed
tyred95816432tyred
urged75316032urged
urped84615282urped
weed85637512_weed
wried95518562wried

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.313570897.8
2DLD Change Limit538002051.56034487.2
3Display Results2052050.0633254.0
 (SQL Overall)1786912051.93692299.1
 
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.