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

59 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
rewards11481399(None) 
regards94112561regards
retards85015001retards
reward106017641reward_
rewarms12439601rewarms
rewords115413981rewords
awards107113452_awards
beards94116672be_ards
bedwards1596392bedwards
bewares12313372bewares
cowards1339612cowards
dewars105117072dewar_s
inwards1138342inwards
leewards1244982leewards
onwards1137172onwards
petards104311152petards
prewarms15406732prewarms
prewarns13456942prewarns
readds84111642re_adds
reads64835272re_a_ds
rearms85114652re_arms
rears54739652re_ar_s
rearwards1344802rearwards
rebars84019832rebar_s
reboards1138772reboards
records105213922records
redwares1239052redwares
reearns749102reearns
regard85215772regard_
relands85214882relands
remands104914882remands
remarks13329982remarks
reparks13249512reparks
rerewards1344642rerewards
retard75018932retard_
rewakes144614982rewakes
rewarded13229522rewarded
rewarder12208232rewarder
rewarders13226452rewarders
rewarm115913492rewar_m
rewaxes173911332rewaxes
rewears102911042rewear_s
reweds104412302rew_eds
rewelds11457412rewelds
rewinds114810482rewinds
rewires104717112rewires
reword106321412reword_
reworks145113602reworks
rewraps12136562rewraps
reynards1244302reynards
ritards8439942ritards
seawards1237202seawards
sewars94018632sewar_s
stewards1236382stewards
swards105415132_swards
towards1138782towards
upwards13135962upwards
vawards14457572vawards
wards97734402__wards

Search took 4 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 Filter1786911076710.390458182.1
2DLD Change Limit107671593.14034290.1
3Display Results59590.0163687.5
 (SQL Overall)178691593.54650392.3
 
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.