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

129 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
tweed9491509(None) 
teed55439261t_eed
tewed94718531tewed
treed65626731treed
twee76827081twee_
tweeds10498431tweeds
tweedy13455931tweedy
tween84413741tween
tweet84823981tweet
weed85637511_weed
atween9166612atween
awed88436032aw_ed
awee76336642awee_
awned96615952awned
bleed85019802bleed
breed85526692breed
creed85727392creed
deed65340902_deed
dewed105020302dewed
dreed75222842dreed
dweeb1137742dweeb
etwee84115332etwee_
etwees9348792etwees
feed84538902_feed
freed95223542freed
geed65435502_geed
gleed75320572gleed
greed75125692greed
heed86437602_heed
hewed125619432hewed
jeed125428502_jeed
jewed165114832jewed
kneed104612052kneed
meed74934702_meed
mewed115218012mewed
need54934152_need
owed86833872ow_ed
owned95113232owned
peed76239182_peed
preed85128112preed
reed55549622_reed
rewed95425452rewed
seed55549482_seed
sewed95325162sewed
skeed105018982skeed
speed85526622speed
steed66024942steed
stewed104814242stewed
swede94413202swede
sweep104715722sweep
sweer84918572sweer
sweet85330522sweet
tamed85528512tamed
taped85327422taped
tared69340052tared
tarweed1137342tarweed
tawed95926192tawed
tawsed10499742tawsed
taxed135620292taxed
ted46446562t__ed
tee38366872t_ee_
teel46335802t_eel
teem66132602t_eem
teemed95114872teemed
teen45938202t_een
tees45353582t_ees
tend56433772t_end
thee78039062thee_
themed125912582themed
tided76322512tided
tied55535212t_ied
tiered73613972tiered
tiled64832942tiled
timed85223612timed
tined65434532tined
tired65228902tired
toed56137042t_oed
toked105626492toked
toled65934922toled
toned65435342toned
toped85631312toped
toted64929482toted
towed95134582towed
toweled112410222toweled
towered112911402towered
toyed96019802toyed
tread64821702tread
tree47745812tree_
treen55622752treen
trees55835762trees
trend64817452trend
tried65026912tried
trued65117692trued
tsked105910032tsked
tubed85818042tubed
tuned64622312tuned
twae74719572twae_
twaes86513662twaes
tweak1257752tweak
tweaked1534402tweaked
tweedle1134192tweedle
tweens9489842tweens
tweeny12477002tweeny
tweeted11336582tweeted
tweets94210102tweets
tweeze18265472tweeze
tweezed20274992tweezed
twerp10398412twerp
twier84713292twier
twined104413122twined
twyer11558522twyer
tyee75131422tyee_
tyees86019452tyees
tyned95915012tyned
typed115815452typed
tyred95816432tyred
wed75843622_w_ed
wee66760812_wee_
weeds95222212_weeds
weedy125115002_weedy
week116428152_week
weel75834082_weel
ween75835462_ween
weep95131652_weep
weer75535092_weer
wees76249122_wees
weet75254152_weet
weld84727732_weld
wend85330452_wend

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 Filter178691538000.1731032896.0
2DLD Change Limit538001292.09325704.7
3Display Results1291290.0304300.0
 (SQL Overall)1786911292.29677827.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.