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

149 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
subways153616(None) 
subway1447071subway_
runways13134442runways
seaways13307512seaways
skyways2043222skyways
subahs114512382sub_ahs
subas74724072sub_a_s
subbass1138032subbass
subwayed1753722subwayed
sunrays1037082sunrays
sways115518462s__ways
airways1336243airways
always12409133_always
anyways1644423anyways
bays97143913__b_ays
brays106723113__brays
bubals103513843bub_als
bubbas94110703bubba_s
byways1734673_byways
cogways1634633cogways
cullays12347703cullays
cutaways1643813cutaways
embays131408333emb_ays
endways1444443endways
flyways19133853flyways
guanays1134953guanays
hubcaps1643543hubcaps
hurrays13386153hurrays
jetways2094053jetways
jubas144614223jub_a_s
jubbahs2143623jubbahs
jubhahs2242353jubhahs
keyways2043373keyways
leeways1354453leeways
logways1434513logways
midways16386183midways
noways12127733_noways
nubias8310093nubia_s
oilways1334873oilways
outlays102610903outlays
outsays102710403outsays
outwars10912793outwars
quays174612043qu__ays
runaways1442853runaways
runway12105973runway_
sabals84618863sab_als
sabbats1138633sabbats
sabras85116363sabra_s
sashays1336333sashays
satays94411683s_atays
says75942103s___ays
schwas14396983schwa_s
scubas103710223scub_a_s
seawans10379943seawans
seaway12309993seaway_
sewans95215903s_ewans
sewars94018633s_ewars
shays116021433s__hays
shipways1944073shipways
shwas116415103s_hwa_s
sideways1545233sideways
skidways1942823skidways
skyway1933343skyway_
slays85723683s__lays
slipways1643463slipways
sobas74424253sob_a_s
someways1644823someways
sowans94215893s_owans
sowars94318013s_owars
spays105520513s__pays
splays114910873s_plays
sprays115913643s_prays
stays86022023s__tays
strays96417933s_trays
suba64926603sub_a__
subadars11125093subadars
subah106015213sub_a_h
subbase1139323subbase
subbases1239063subbases
subcause1265823subcause
subclans1247413subclans
subclass1246623subclass
subdeans1137203subdeans
subdebs1236483subdebs
subduals1156293subduals
subdues1099893subdues
subdwarf1743383subdwarf
subdwarfs1841713subdwarfs
subers85722643sub_ers
subgoals1145553subgoals
subgums1235893subgums
subheads1496533subheads
sublate9315363sublate
sublates10315003sublates
sublets92616703sublets
sublots92410913sublots
submiss1138083submiss
submits1139753submits
subnets92512083subnets
suborns939493suborns
subpar1048663subpa_r
subpart11311123subpart
subparts1246903subparts
subrace11313003subrace
subraces12313033subraces
subs66037123sub___s
subsale9310543subsale
subsales10310123subsales
subsets92813103subsets
subtask1335713subtask
subtasks1444493subtasks
subtaxa1644483subtaxa
subtly11249263subtly_
suburbs1136503suburbs
subwaying1843873subwaying
succahs1435323succahs
sugars7312423su_gars
sukkahs1382703sukkahs
suldans8299723suldans
sulfas9311563sulfa_s
sultans72411833sultans
sumacs105512103su_macs
summas104313163summa_s
sunbeams1243963sunbeams
sundaes8313093sundaes
sunnahs10326593sunnahs
sunnas63914563sunna_s
sunray9310123sunray_
suntans72111733suntans
sunward1137653sunward
sunwards1236443sunwards
surahs94515543su_rahs
suras55336333su_ra_s
surpass938283surpass
surras65919533surra_s
surreys10489443surreys
surveys13357573surveys
sutras64818593sutra_s
suttas63813793sutta_s
swabs105817273s__wabs
swags94921253s__wags
swans84625013s__wans
swaps104819203s__waps
swats85726863s__wats
sway107128233s__way_
tubas75119583tub_a_s
unlays93810493_unlays
unsays9399543_unsays
ways107737953___ways

Search took 8 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 Limit1340271496.79619721.5
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.26524596.1
 
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.