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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

64 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
tweeds1049843(None) 
tweed94915091tweed_
tweedy13455931tweedy
tweens9489841tweens
tweets94210101tweets
weeds95222211_weeds
bleeds95211592bleeds
breeds94914882breeds
creeds94714772creeds
deeds75423762_deeds
dweebs1233652dweebs
etwees9348792etwee_s
feeds94921142_feeds
gleeds84711622gleeds
greeds84314282greeds
heeds95420422_heeds
meeds84920272_meeds
needs65719632_needs
reeds65430902_reeds
reweds104412302reweds
seeds64330062_seeds
speeds94316052speeds
steeds73814882steeds
swedes102711892swedes
sweeps114110512sweeps
sweets94214432sweets
tarweeds1244272tarweeds
teds54932572t__eds
teed55439262t_eed_
teels55726372t_eels
teems76019782t_eems
teens56227482t_eens
tees45353582t_ee_s
tends65425582t_ends
tewed94718532tewed_
treads74817922treads
treed65626732treed_
treens65317872treens
trees55835762tree_s
trends75513542trends
twaes86513662twae_s
tweaks1335962tweaks
twee76827082twee__
tweedle1134192tweedle
tweedles1234112tweedles
tween84413742twee_n
tweeny12477002tweeny
tweet84823982twee_t
tweeze18265472tweeze
tweezes19345702tweezes
twerps11345152twerps
twiers95410162twiers
twyers12497412twyers
tyees86019452tyee_s
weds86628932_w_eds
weed85637512_weed_
weedy125115002_weedy
weeks125017862_weeks
weens85224052_weens
weeps104120562_weeps
wees76249122_wee_s
weets85427722_weets
welds94719162_welds
wends95822812_wends

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.346516448.0
2DLD Change Limit82551642.17038041.9
3Display Results64640.0302133.3
 (SQL Overall)178691642.54670185.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.