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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

205 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
runway1210597(None) 
runaway1343681runaway
runways13134441runways
runaways1442852runaways
runny84613482run_ny
runty86119042run_ty
subway1447072subway
sunray9310122sunray
unlay84613702_unlay
unsay83212842_unsay
unwary1239822_unwary
airway1237693airway
alway116113923_alway
anyway1534803anyway
archway1844893archway
areaway1335913areaway
auntly95211063auntly
aunty85919813aun_ty
away108024223__away
benday123810813benday
buna64730723bun_a_
bunas75126573bun_as
bunchy16437463bunchy
bunny104715803bun_ny
bunya103810093bunya_
bunyas11359433bunyas
byway1647533_byway
cogway1566183cogway
crunchy17324763crunchy
cullay113910173cullay
cuneal8611513cuneal
cutaway1544433cutaway
dunam8313733dun_am
dungy104713643dun_gy
flyway18134693flyway
freeway1635603freeway
fungal10388733fungal
funky154315133fun_ky
funny114614833fun_ny
gangway1544233gangway
greenway1543853greenway
grungy11345973grun_gy
guanay1037913guanay
gunky135514113gun_ky
gunman9299453gunman
gunny94413663gun_ny
gunplay1343233gunplay
gunwale1134733gunwale
hungry1334973hungry
hunkey164210883hunkey
hunky155417733hun_ky
hurray12459913hurray
inlay85214323_inlay
jetway19105273jetway
jungly17407693jungly
junky194513233jun_ky
junta123713673junta_
juntas134210503juntas
keyway1943823keyway
kuna85120703kun_a_
laneway1345273laneway
leeway1255883leeway
logway1335913logway
luna46229853lun_a_
lunacy1136843lunacy
lunar57017313lun_ar
lunas55025013lun_as
lungan74710213lungan
luny77324133lun__y
midway15327153midway
nay66952773__n_ay
nongay10169153nongay
nonwar9159423nonwar
noway111112843_noway
oilway1235743oilway
onlay84212943_onlay
outlay92711793outlay
outsay92611873outsay
outwar91011513outwar
puna65331653pun_a_
punas74826753pun_as
punchy16398523punchy
punily11311773punily
punka114515483punka_
punkah15347093punkah
punkas123410673punkas
punkey154011173punkey
punky144419393pun_ky
punny104217713pun_ny
punty106021613pun_ty
puny95526993pun__y
quay164618353qu__ay
raceway1546133raceway
railway1345313railway
randan7315253randan
randy95022083ran_dy
rangy95320383ran_gy
rankly133910453rankly
raunchy15284313raunchy
rawly115115833r_awly
ray66361993r___ay
redbay1238333redbay
relay84424673r_elay
renal55929503ren_al
renewal1038703renewal
rental63922023rental
repay104818453r_epay
replay113412923replay
resay85320543r_esay
reunify1344453reunify
rewan85623663r_ewan
rewax155713923r_ewax
rindy95717393rin_dy
roadway1464613roadway
rollway1344653rollway
ropeway1544773ropeway
roundly1136723roundly
routeway1443413routeway
rowan85418733r_owan
rowdy125711533r_owdy
ruana5312423ruana_
ruanas6311263ruanas
rubbly133710613rubbly
rubby124413863ru_bby
ruby97819943ru__by
ruddy104511753ru_ddy
rudely10389973rudely
rudery10419033rudery
ruffly15336673ruffly
ruga56121233ru_ga_
rugae65114763ru_gae
rugal65916093ru_gal
rugby11448133ru_gby
ruly76323143ru__ly
rumba93612513rumba_
rumbas102512013rumbas
rumbly134412163rumbly
rummy124212413ru_mmy
rumply13348573rumply
run36244993run___
runback1556603runback
rundle73214233rundle
rune45236303run__e
runes55530223run_es
rung56429983run__g
rungs611819403run_gs
runic73615773run_ic
runkle103611543runkle
runlet63821413runlet
runnel63510663runnel
runner63814463runner
runoff1235413runoff
runout6414873runout
runs46438083run__s
runt46647993run__t
runts55927633run_ts
rupiah1146213rupiah
rural55821173ru_ral
rurban849043rurban
rushy115414813ru_shy
rusty85221053ru_sty
rutty85617803ru_tty
seaway12309993seaway
skyway1933343skyway
subways1536163subways
sundae7312873sundae
sundry1057943sundry
sunna55016063sunna_
sunnah9369353sunnah
sunnas63914563sunnas
sunny84917743sun_ny
sunrays1037083sunrays
suntan62613003suntan
sunward1137653sunward
sway107128233__sway
thruway1643163thru_way
trainway1444223trainway
tramway1544863tramway
tuna45127843tun_a_
tunas54224123tun_as
tunny86515033tun_ny
unai44824783_un_ai
unary8315993_unary
unau43924153_un_au
unban72114333_unban
unbar71913613_unbar
uncap9312283_uncap
uncoy104111413_uncoy
undy85015163_un_dy
uneasy9278853_uneasy
unhat81119263_unhat
unify113611113_unify
unity84918493_unity
unjam1448723_unjam
unlays93810493_unlays
unman72715423_unman
unsays9399543_unsays
unweary1335843_unweary
unwed94114873_unwed
unwet84423173_unwet
unwit84417523_unwit
unwon84512343_unwon
unwrap11126323_unwrap
way96757663___way
windway1745153windway

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162054.82623356.0
3Display Results2052050.0633254.0
 (SQL Overall)1786912055.27933849.4
 
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.