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

111 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
keyway194382(None) 
keyways2043371keyways
anyway1534802anyway
byway1647532_byway
flyway18134692flyway
heyday1635142heyday
jetway19105272jetway
keypad1633822keypad
keypal1534892keypal
leeway1255882leeway
seaway12309992seaway
skyway1933342skyway
airway1237693airway
alleyway1752823alleyway
alway116113923_alway
anyways1644423anyways
areaway1335913areaway
away108024223__away
belay105021523be_lay
beltway1564373beltway
benday123810813benday
betray111511443betray
bewray14147733bewray
bikeway1944313bike_way
byways1734673_byways
cogway1566183cogway
decay114718483de_cay
deejay1734523deejay
deewan10267553deewan
defray1337643defray
delay94820633de_lay
deray95024183de_ray
dewan95718043de_wan
dewar95817733de_war
dewax165510853de_wax
dewy115419023de_w_y
embay123410603_embay
essay867623_essay
everyway2041933everyway
eyas76427433_ey_as
eyra76217553_eyra_
eyras84715923_eyras
eyry106315883_ey_ry
feyly14429513fey_ly
flyaway1943163flyaway
flyways19133853flyways
freeway1635603freeway
getaway1444013getaway
headway1745553headway
heydays1734143heydays
heydey1634633heydey
jetways2094053jetways
kay106745543k___ay
kayak1138363kay_ak
kea76540913ke__a_
keas86337093ke__as
kebab134312003ke_bab
kebar115113533ke_bar
keblah1545313keblah
keddah1534273keddah
keenly1336373keenly
kelly124617023ke_lly
kelpy145110683ke_lpy
kenaf12316033ke_naf
kerry124916093ke_rry
kersey1336793kersey
key105833333ke___y
keycard1743663keycard
keyed1369393key_ed
keying1438043keying
keypads1743343keypads
keypals1634353keypals
keys116322163key__s
keyset13411533keyset
keyword1844563keyword
kyak105213633k_y_ak
kyar116916843k_y_ar
kyat116025523k_y_at
layaway1643933layaway
leeways1354453leeways
logway1335913logway
mayday1535883mayday
midway15327153midway
naysay1234973naysay
newly114610203ne_wly
newsy11489393ne_wsy
noway111112843_noway
oilway1235743oilway
payday1536613payday
psywar1443323psywar
redbay1238333redbay
relay84424673re_lay
repay104818453re_pay
replay113412923replay
resay85320543re_say
rewan85623663re_wan
rewax155713923re_wax
runway12105973runway
seawan94111223seawan
seaways13307513seaways
sewan85921293se_wan
sewar85421103se_war
skidway1843083skidway
skyways2043223skyways
subway1447073subway
sway107128233__sway
takeaway1843053takeaway
veejay1933703veejay
way96757663___way
waylay1535453waylay
yay96948713__y_ay

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.423422437.4
2DLD Change Limit1127161115.43620735.1
3Display Results1111110.0303700.0
 (SQL Overall)1786911115.88930343.2
 
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.