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 “waysides” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
waysides154445(None) 
daysides1335961daysides
wayside1435181wayside_
apsides103911302_apsides
asides75118872_a_sides
dayside1236172dayside_
farsides1237992farsides
hayrides1536882hayrides
quaysides2243282quaysides
weaksides1742472weaksides
abides94719893_a_bides
aides65336603_a__ides
alsikes1137263_alsikes
amides95722663_a_mides
aphides134711203_aphides
arsines73518813_arsines
aside65122083_a_side_
assizes1638453_assizes
azides165113803_a_zides
backsides1887693backsides
banksides16104853banksides
bedsides1246533bedsides
besides104814533_besides
capsids1239333capsid_s
capsizes2147203capsizes
carbides133111693carbides
cassines103116613cassines
cassises103811743cassises
cyanides14258003cyanides
daisies84217093daisi_es
dassies84418663dassi_es
daytimes1434483daytimes
depsides1238503depsides
easies64126633ea_si_es
falsies103515013falsi_es
farside1138603farside_
hagrides1337623hagrides
halides113416663ha_lides
hayride1437323hayride_
hayseeds1543283hayseeds
haywires1744043haywires
insides8512653_insides
jassids1586143jassid_s
joyrides1943853joyrides
lakesides1444093lakesides
landsides11116743landsides
lapides103012043la_pides
lassies74420103lassi_es
lysines10369093_lysines
mysids1246563_mysid_s
nearsides1044513nearsides
offsides1543393offsides
outsides92513233outsides
palsies94420273palsi_es
pansies94521983pansi_es
passades1139203passades
passives13228823passives
patsies93919483patsi_es
presides11414913presides
pyxides2034423_pyxides
quayside2143473quayside_
rachides141511223rachides
raphides14188393raphides
rawhides15145543rawhides
resides84523283_resides
roadsides1144463roadsides
sassies74719263sassi_es
sayids104310973say_id_s
sayyids14193833sayyid_s
seasides938743seasides
sides65838363___sides
subsides11410823subsides
tansies74521243tansi_es
tassies74918933tassi_es
topsides1137203topsides
upsides10319633_upsides
waddies124214753waddi_es
wades95634143wa___des
wadies105121203wa_di_es
waffies163611443waffi_es
wahines133111173wa_hines
waives123714183wa__ives
walies95324523wa_li_es
wallies103320743walli_es
warsles103413643wars_les
warstles11368803warstles
wartimes1336963wartimes
washes124425493wa_s_hes
wastes96224883wa_s_tes
watersides1445533watersides
wavies125019843wa_vi_es
waybills1643163waybills
weakside1642843weakside_
websites1335183websites
whatsises1543203whatsises
whosises1435333whosises
wides94832823w___ides
wussies103411083wussi_es

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 Filter1786911461620.453394461.4
2DLD Change Limit146162987.39319770.3
3Display Results98980.0462130.4
 (SQL Overall)178691987.89222642.0
 
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.