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

125 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
skyway193334(None) 
skyways2043221skyways
anyway1534802anyway
byway1647532_byway
flyway18134692flyway
keyway1943822keyway
seaway12309992seaway
skidway1843082skidway
skycap1742912skycap
skyey15537222sky_ey
skyman1535312skyman
skywalk1642352skywalk
skyward1843862skyward
subway1447072subway
sway107128232s__way
airway1237693airway
alway116113923_alway
anyways1644423anyways
away108024223__away
bikeway1944313bikeway
byways1734673_byways
cogway1566183cogway
flyaway1943163flyaway
flyways19133853flyways
heyday1635143heyday
jetway19105273jetway
kay106745543_k__ay
keyways2043373keyways
kyak105213633_ky_ak
kyar116916843_ky_ar
kyat116025523_ky_at
layaway1643933layaway
leeway1255883leeway
logway1335913logway
mayday1535873mayday
midway15327153midway
naysay1234973naysay
noway111112843_noway
oilway1235743oilway
okay115917663ok__ay
payday1536613payday
psywar1443323psywar
runway12105973runway
sashay1238363sashay
satay84718463s_atay
say67264763s___ay
schwa13426843schwa_
schwas14396983schwas
seawan94111223seawan
seaways13307513seaways
sewan85921293s_ewan
sewar85421093s_ewar
shay107133343s__hay
shipway1844213shipway
showy145714003show_y
shwa106014963s_hwa_
shwas116415103s_hwas
shyly144811573shy_ly
sideway1445673sideway
ska76925863sk__a_
skag96321513sk__ag
skanky12476963skanky
skas85325713sk__as
skat87037893sk__at
skean94415623sk_ean
skerry13356103skerry
skew116218763skew__
skewed145610233skewed
skewer13519603skewer
skews125413803skew_s
skiddy1533633skiddy
skidways1942823skidways
skiey125012893sk_iey
skimpy17475723skimpy
skinny13456613skinny
skivvy1932783skivvy
skiwear1442523skiwear
skoal93811453sk_oal
skua86113153sk_ua_
skuas95611733sk_uas
skunky12436163skunky
sky106420993sk___y
skybox2242293skybox
skycaps1842703skycaps
skyed13529923sky_ed
skying14399983skying
skyjack2242763skyjack
skylark1343273skylark
skylit1338273skylit
skymen1535313skymen
skysail1462833skysail
skywalks1742193skywalks
skywards1943373skywards
slay76436383s__lay
slipway1543873slipway
slowly1237153slowly
slyly11489533sly_ly
snowy115011563snow_y
someway1545613someway
sowar85821343s_owar
soya75724433soy_a_
soyas84520913soy_as
spay96631663s__pay
splay105816043s_play
spray106720063s_pray
stay78333723s__tay
stewy116112063stew_y
strawy1210312823strawy
stray88525573s_tray
stylar9358113stylar
stymy13358293sty_my
styrax1675243styrax
subways1536163subways
sunray9310123sunray
swab96825313s__wab
swag87526733s__wag
swam96329983s__wam
swamy136714403s__wamy
swan76631313s__wan
swap95925433s__wap
swat77244443s__wat
sways115518463s__ways
way96757663___way
waylay1535453waylay
yay96948713__y_ay

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.1401276364.3
2DLD Change Limit1127161256.43617513.4
3Display Results1251250.0333787.9
 (SQL Overall)1786911256.60927037.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.