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

106 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
relay8442467(None) 
belay105021521belay
delay94820631delay
relax124817801relax
relays94316751relays
rely75428951rel_y
repay104818451repay
replay113412921replay
resay85320541resay
allay85620392allay
belady12489932belady
belays114313852belays
belly104625492belly
clay95927412_clay
decay114718482decay
delays104014052delays
delly96023872delly
deray95024182deray
eely77725212eel_y
elan46734242_elan
elmy95616792_elmy
felly114922802felly
flay106332802_flay
inlay85214322inlay
jelly154218252jelly
kelly124617022kelly
kelpy145110682kelpy
lay68865352__lay
mealy104422182mealy
melty104918362melty
nelly84618812nelly
onlay84212942onlay
play95928982_play
prelacy1437582prelacy
prelaw1139102prelaw
prepay13310312prepay
rally84725902rally
ray66361992r__ay
read55942532re_ad
ready94821502ready
real45750292re_al
really93315612really
realm75621622realm
reals55038652reals
realty92713692realty
ream65841612re_am
reap65934742re_ap
rear45644552re_ar
rebar75420192rebar
rebuy104714682rebuy
recap95718022recap
reclad9311872reclad
redan66125012redan
redbay1238332redbay
redly94217202redly
redry94314362redry
reedy910020292reedy
reefy114217702reefy
reeky125416262reeky
reflag1098082reflag
refly113914562refly
refry114412462refry
regal65023792regal
rehab10312442rehab
reify114814972reify
rekey124014732rekey
relace83122152relace
relaid75518442relaid
reland75920432reland
relate64033632relate
relayed113212752relayed
relet54749822relet
relic74623362relic
relit55340682relit
reload7413892reload
reloan6415692reloan
reman75730152reman
remap95418102remap
renal55929502renal
repays113813972repays
replan83215822replan
replays12399762replays
reply104015852reply
reran57329102reran
resat55139682resat
resaw84117252resaw
resays93714152resays
retag63618412retag
retax124517972retax
retry84718082retry
rewan85623662rewan
rewax155713922rewax
riley84420582riley
ruly76323142rul_y
selah8319612selah
slay76436382_slay
splay105816042splay
tela45532972tela_
telae54323292telae
telly84920822telly
unlay84613702unlay
vealy115817772vealy
vela75725542vela_
velar85817632velar
virelay1335942virelay
welly114620012welly

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.310576422.6
2DLD Change Limit538001061.62633087.3
3Display Results1061060.0303533.3
 (SQL Overall)1786911061.96690890.6
 
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.