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

115 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
dayside123617(None) 
daysides1335961daysides
wayside1435181wayside
aside65122082_a_side
daisied93410012daisied
dassie74615572dassi_e
daytime1344782daytime
depside1138402depside
farside1138602farside
hayride1437322hayride
quayside2143472quayside
waysides1544452waysides
abide86223713_a_bide
adamsite1144423adamsite
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
capsid11312413capsid_
capsids1239333capsids
capsize2037623capsize
carbide126112493carbide
cassine93817283cassine
cyanide13298843cyanide
dacite91115883da_cite
daisies84217093daisies
dallied93713613dallied
dapsone1038463dapsone
darkie113714013darki_e
dashed115920563da_shed
dassies84418663dassies
dasyure1153823dasyure
dative10311813da_tive
dautie72914703dauti_e
dawtie103011093dawti_e
daybed13438673daybed_
daybeds14234473daybeds
daycare1355093daycare
daylily1434983daylily
daylit10512493dayli_t
daymare1375633daymare
days87637133days___
daysman1335053daysman
daysmen1335083daysmen
daystar1143443daystar
daytimes1434483daytimes
debride1138593debride
decide104116873d_ecide
deicide1149403deicide
depsides1238503depsides
deride84420033d_eride
desire7415303d_esire
diamide1138473diamide
diapsid1146703diapsid_
diapsids1244753diapsids
diopside1245643diopside
dioxide1656303dioxide
divide113410893d_ivide
dockside16154743dockside
donsie7613643donsi_e
downside1345293downside
dynode1135023d_ynode
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_
nearside944913nearside
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
topside1037733topside
upside9289803_upside
weakside1642843weakside

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.406440125.6
2DLD Change Limit1340271156.68620045.9
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.13825033.8
 
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.