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

214 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
subway144707(None) 
subways1536161subways
runway12105972runway
seaway12309992seaway
skyway1933342skyway
suba64926602sub_a_
subah106015212sub_ah
subas74724072sub_as
subpar1048662subpar
subtly11249262subtly
subwayed1753722subwayed
sunray9310122sunray
sway107128232s__way
airway1237693airway
alway116113923_alway
anyway1534803anyway
away108024223__away
bay89661643__b_ay
bray95232903__bray
bubal94218213bub_al
bubba84311803bubba_
bubbas94110703bubbas
bubbly124110353bubbly
bubby115013933bub_by
byway1647533_byway
cogway1566183cogway
cubby145212123cub_by
cullay113910173cullay
cutaway1544433cutaway
embay123410603emb_ay
flyway18134693flyway
fubar1039923fub_ar
fubsy13589273fub_sy
guanay1037913guanay
hubbly16478413hubbly
hubby155011403hub_by
hubcap1553993hubcap
hurray12459913hurray
jetway19105273jetway
juba134916983jub_a_
jubas144614223jub_as
jubbah2034353jubbah
jubhah2142803jubhah
keyway1943823keyway
leeway1255883leeway
logway1335913logway
midway15327153midway
noway111112843_noway
nubbly13369673nubbly
nubby125011033nub_by
nubia7311233nubia_
nubias8310093nubias
oilway1235743oilway
outlay92711793outlay
outsay92611873outsay
outwar91011513outwar
quay164618353qu__ay
rubbly133710613rubbly
rubby124413863rub_by
ruby97819943rub__y
runaway1343683runaway
runways13134443runways
sabal75422483sab_al
sabbat10314713sabbat
sabra75317853sabra_
sabras85116363sabras
sashay1238363sashay
satay84718463s_atay
say67264763s___ay
schwa13426843schwa_
schwas14396983schwas
scuba94211593scub_a_
scubas103710223scub_as
seawan94111223seawan
seaways13307513seaways
sewan85921293s_ewan
sewar85421103s_ewar
shay107133343s__hay
shipway1844213shipway
showy145714013show_y
shwa106014963s_hwa_
shwas116415103s_hwas
sideway1445673sideway
skidway1843083skidway
skyways2043223skyways
slay76436383s__lay
slipway1543873slipway
slowly1237153slowly
snowy115011563snow_y
snubby1344533snub_by
soba64927923sob_a_
sobas74424253sob_as
someway1545613someway
sowar85821343s_owar
spay96631663s__pay
splay105816043s_play
spray106720063s_pray
stay78333723s__tay
stewy116112063stew_y
strawy1210312823strawy
stray88525573s_tray
stubbly1444473stubbly
stubby1345043stub_by
suably112814533suably
sub55445553sub___
subadar10125583subadar
subahs114512383subahs
subalar9118073subalar
subbase1139323subbase
subbass1138033subbass
subbed114116673subbed
subclan1147173subclan
subdean1037403subdean
subdeb1137523subdeb
subdual10126713subdual
subdue9128493subdue
subdwarf1743383subdwarf
suber74924503sub_er
subers85722643subers
subfix1835073subfix
subgoal1046323subgoal
subgum1136133subgum
subhead1387693subhead
subito8410453subito
sublate9315363sublate
sublet82827243sublet
sublot82315523sublot
submit10312673submit
subnet82520933subnet
suboral92011993suboral
suborn8310013suborn
suboval12216723suboval
subpart11311123subpart
subrace11313003subrace
subs66037123sub__s
subsale9310543subsale
subsea82610193subsea
subset83122583subset
subsidy1345973subsidy
subtask1335713subtask
subtaxa1644483subtaxa
subtle82113433subtle
suburb1037163suburb
subwaying1843873subwaying
succah1336643succah
sucky144415503su_cky
sudary1038703sudary
sudsy95010683su_dsy
suety85318493su_ety
sugar6312913su_gar
sugary1039013sugary
sukkah12123733sukkah
sulcal8311273sulcal
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sulky124715363su_lky
sully84622903su_lly
sultan63012593sultan
sultry938463sultry
sumac99514883su_mac
summa94713313summa_
summae103911013summae
summary14297353summary
summas104313163summas
sunbeam1146053sunbeam
sunbeamy1542353sunbeamy
sundae7312873sundae
sundry1057943sundry
sunna55016063sunna_
sunnah9369353sunnah
sunnas63914563sunnas
sunny84917743su_nny
sunrays1037083sunrays
suntan62613003suntan
sunward1137653sunward
supply1346893supply
supra73614253supra_
sura45740293su_ra_
surah86823253su_rah
sural55931263su_ral
suras55336333su_ras
surely93816463surely
surety93515013surety
surfy115319473su_rfy
surgy95118523su_rgy
surly85124433su_rly
surra55521343surra_
surras65919533surras
surrey94414583surrey
surtax1337843surtax
survey124111673survey
sutra54217933sutra_
sutras64818593sutras
sutta54015333sutta_
suttas63813793suttas
swab96825313s__wab
swag87526733s__wag
swam96329983s__wam
swamy136714403s__wamy
swan76631313s__wan
swap95925433s__wap
swat77244443s__wat
sways115518463s__ways
tsuba745563tsub_a_
tuba65422363tub_a_
tubae74716643tub_ae
tubal75517203tub_al
tubas75119583tub_as
tubby124511403tub_by
unlay84613703_unlay
unsay83212843_unsay
unwary1239823_unwary
way96757663___way

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162145.75019602.8
3Display Results2142140.0802675.0
 (SQL Overall)1786912146.22028728.5
 
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.