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

126 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
runways1313444(None) 
runaways1442851runaways
runway12105971runway_
runaway1343682runaway_
subways1536172subways
sunrays1037082sunrays
unlays93810492_unlays
unsays9399542_unsays
airways1336243airways
always12409133_always
anyways1644423anyways
archways1944063archways
areaways1444493areaways
bendays13327513bendays
bendways1743733bendways
bunas75126573bun_a_s
bunyas11359433bunya_s
byways1734673_byways
cogways1634633cogways
cullays12347703cullays
cutaways1643813cutaways
dunams937833dun_ams
endways1444443endways
flyways19133853flyways
freeways1744723freeways
fungals11276783fungals
gangways1643733gangways
greenways1643433greenways
guanays1134953guanays
gunplays1442713gunplays
gunwale1134733gunwale
gunwales1244733gunwales
hunkeys17386193hunkeys
hurrays13386153hurrays
inlays9389873_inlays
jetways2094053jetways
juntas134210503junta_s
keyways2043373keyways
laneways1444573laneways
leeways1354453leeways
logways1434513logways
longways1543873longways
lunars65012813lun_ars
lunas55025013lun_a_s
lungans8399053lungans
midways16386183midways
nays75931593__n_ays
nongays11176533nongays
nonwars10109003nonwars
noways12127733_noways
oilways1334873oilways
onlays9398713_onlays
outlays102610903outlays
outsays102710403outsays
outwars10912793outwars
punas74826753pun_a_s
punkahs16284783punkahs
punkas123410673punka_s
punkeys16366493punkeys
quays174612043qu__ays
raceways1645233raceways
railways1444603railways
randans8313213randans
rays77642353r___ays
redbays1336013redbays
relays94316753r_elays
renewals1137283renewals
rentals74017483rentals
repays113813973r_epays
replays12399763replays
resays93714153r_esays
roadways1564613roadways
rollways1444233rollways
ropeways1644053ropeways
routeways1543153routeways
rowans95715343r_owans
ruanas6311263ruana_s
rumbas102512013rumba_s
runback1556603runback
runbacks1655903runbacks
rundles83214713rundles
runes55530223run__es
rungs611819403run__gs
runkles114111943runkles
runless72810423runless
runlets73310773runlets
runnels7329163runnels
runners74212453runners
runny84613483run_ny_
runoffs1343013runoffs
runouts737353runouts
runs46438083run___s
runts55927633run__ts
runty86119043run_ty_
rupiahs1253333rupiahs
seaways13307513seaways
skyways2043223skyways
subway1447073subway_
sundaes8313093sundaes
sunnahs10326593sunnahs
sunnas63914563sunna_s
sunray9310123sunray_
suntans72111733suntans
sunward1137653sunward
sunwards1236443sunwards
sways115518463__sways
thruways1742503thru_ways
trainways1543023trainways
tramways1643723tramways
tunas54224123tun_a_s
unais53420773_un_ais
unaus53216573_un_aus
unbans81912623_unbans
unbars82113033_unbars
uncaps1039823_uncaps
uneasy9278853_uneasy
unhats91110623_unhats
unjams1555703_unjams
unlay84613703_unlay_
unmans82211993_unmans
unsay83212843_unsay_
unwary1239823_unwary
unwits9389893_unwits
unwraps1255513_unwraps
ways107737953___ways
windways1845043windways

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271265.89322743.4
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.34528162.5
 
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.