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

100 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
redly9421719(None) 
redry94314361redry
refly113914561refly
rely75428951re_ly
reply104015851reply
agedly1136462agedly
aridly105513702aridly
badly114918762badly
belly104625492belly
deadly113811472deadly
delly96023872delly
eddy93912092_eddy
edgy94713522_edgy
eely77725212_eely
felly114922802felly
ferly115517352ferly
feyly14429512feyly
freely12310952freely
godly104913292godly
greyly13316542greyly
hedgy134510742hedgy
idly85617322_idly
jelly154218252jelly
kelly124617022kelly
ledgy105712012ledgy
lewdly1334392lewdly
madly115218132madly
mealy104422182mealy
medfly1535222medfly
medley1298332medley
neddy10479872neddy
nelly84618812nelly
newly114610202newly
oddly1037162oddly
predry1237862predry
rally84725902rally
rawly115115832rawly
readily11711402readily
ready94821502ready
real45750292real_
really93315612really
realm75621622realm
reals55038652reals
realty92713692realty
rebuy104714682rebuy
red46755802red__
redan66125012redan
redbay1238332redbay
redd66323172red_d
reddle83815912reddle
redds74617832redds
rede55037662red_e
reded74829112reded
redefy13388762redefy
redeny102712732redeny
redes65139122redes
redeye103811792redeye
redia65524482redia
redid74922392redid
redip87816962redip
redleg839262redleg
redo56029362red_o
redon65424882redon
redos65126762redos
redox134714232redox
reds56042862red_s
redub84212412redub
redux133811102redux
redye94413462redye
reedily1179602reedily
reedy910020282reedy
reefy114217702reefy
reeky125416262reeky
reel45240532reel_
reels55333262reels
refry114412462refry
reify114814972reify
rekey124014732rekey
relay84424672relay
repay104818452repay
replay113412922replay
resay85320542resay
retry84718082retry
ridgy104110642ridgy
ridley10169542ridley
roily86121112roily
ruddy104511752ruddy
rudely10389972rudely
ruly76323142r_uly
sadly94519122sadly
sedgy104512782sedgy
seely84522632seely
teddy10489492teddy
telly84920822telly
tiredly1136782tiredly
trebly1138972trebly
vealy115817772vealy
wedgy13479792wedgy
welly114620012welly
wetly114511712wetly

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.0931921408.6
2DLD Change Limit538001001.62633087.3
3Display Results1001000.0303333.3
 (SQL Overall)1786911001.749102167.5
 
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.