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

88 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
relay84424671relay
repay104818451repay
resay85320541resay
rewan85623661rewan
rewax155713921rewax
alway116113922alway
areaway1335912areaway
away108024222_away
belay105021522belay
bewray14147732bewray
byway1647532byway
decay114718482decay
delay94820632delay
deray95024182deray
dewan95718042dewan
dewar95817732dewar
dewax165510852dewax
dewy115419022dew_y
freeway1635602freeway
jetway19105272jetway
keyway1943822keyway
leeway1255882leeway
newly114610202newly
newsy11489392newsy
noway111112842noway
prepay13310312prepay
prewar114712582prewar
raceway1546132raceway
rawly115115832rawly
ray66361992r__ay
read55942532re_ad
ready94821502ready
real45750292re_al
ream65841612re_am
reap65934742re_ap
rear45644552re_ar
rebar75420192rebar
rebuy104714682rebuy
recap95718022recap
redan66125012redan
redbay1238332redbay
redly94217202redly
redry94314362redry
reedy910020292reedy
reefy114217702reefy
reeky125416262reeky
refly113914562refly
refry114412462refry
regal65023792regal
rehab10312442rehab
reify114814972reify
rekey124014732rekey
relax124817802relax
relays94316752relays
rely75428952re_ly
reman75730152reman
remap95418102remap
renal55929512renal
repays113813972repays
replay113412922replay
reply104015852reply
reran57329102reran
resat55139682resat
resaw84117252resaw
resays93714162resays
retag63618412retag
retax124517972retax
retry84718082retry
rewake135218462rewake
reward106017642reward
rewarm115913492rewarm
rewash1237672rewash
rewear93012002rewear
rewed95425452rewed
rewet85135152rewet
rewin85623962rewin
rewon86920582rewon
rewrap11127532rewrap
ropeway1544772ropeway
rowan85418732rowan
rowdy125711532rowdy
runway12105972runway
seaway12309992seaway
sewan85921292sewan
sewar85421102sewar
sway107128232_sway
way96757662__way
wireway1646042wireway

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 Filter178691538000.530337152.8
2DLD Change Limit53800882.97018114.5
3Display Results88880.0302933.3
 (SQL Overall)178691883.53050620.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.