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

101 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
wayside143518(None) 
dayside1236171dayside
waysides1544451waysides
aside65122082_a_side
daysides1335962daysides
farside1138602farside
hayride1437322hayride
quayside2143472quayside
weakside1642842weakside
abide86223713_a_bide
aide56045003_a__ide
alsike1047913_alsike
amide86128483_a_mide
apsides103911303_apsides
arsine64021043_arsine
asides75118873_a_sides
assize1538633_assize
azide155617163_a_zide
backside17108143backside
bankside15115653bankside
bedside1156843bedside
beside95114613_beside
capsid11312423capsid_
capsids1239333capsids
capsize2037623capsize
carbide126112493carbide
cassine93817283cassine
cyanide13298843cyanide
daisied93410013daisied
dassie74615573dassi_e
daytime1344783daytime
depside1138413depside
falsie93513853falsi_e
farsides1237993farsides
gawsie1038463gawsi_e
hagride1237553hagride
halide103417993ha_lide
hayrides1536883hayrides
hayseed1435633hayseed
haywire1644743haywire
inside7613453_inside
jassid1467223jassid_
jassids1586143jassids
joyride1853753joyride
lakeside1344673lakeside
landside10147443landside
lassie64917743lassi_e
lysine94210553_lysine
massive12289773massive
mysid11610693_mysid_
mysids1246563_mysids
naysaid1145313naysaid_
nearside944923nearside
offside1453693offside
onside7511803_onside
outside82414193outside
palsied102911303palsied
passade1039233passade
passive12239593passive
preside10715613preside
quaysides2243283quaysides
raphide13138073raphide
rawhide14134973rawhide
raylike14269253raylike
reside74224933_reside
roadside1044893roadside
sayid95516723say_id_
sayids104310973say_ids
sayyid13185353sayyid_
sayyids14193833sayyids
seaside839693seaside
side55444493___side
subside10410453subside
tassie66017023tassi_e
topside1037743topside
upside9289803_upside
waddie114013323waddi_e
waddied13358563waddied
wade85237063wa___de
waffie15338563waffi_e
wagsome1345213wagsome
wahine123813013wa_hine
waisted114210943waisted
waive114214603wa__ive
wallie93216803walli_e
warlike142410473warlike
warsle93112923wars_le
warsled112910443warsled
warstle10328013warstle
wartime1237743wartime
washed135521503wa_shed
waste86125053wa_s_te
wasted104423023wa_sted
waterside1345803waterside
waxlike21185973waxlike
waybill1543723waybill
waylaid1445093waylaid_
ways107737953ways___
weaksides1742473weaksides
website1235323website
wide85235413w___ide

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.466383457.1
2DLD Change Limit1340271016.83019623.3
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.34224338.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.